ITMV_PLOC_VW

(SQL View)
 Index Back

Item Supplier Priority Loc Vie


SELECT A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.INV_ITEM_ID , A.ITMV_PRIORITY_LOC , C.NAME1 , B.PRICE_SETID , B.PRICE_VENDOR , B.PRICE_LOC , B.CURRENCY_CD , B.SHIP_TYPE_ID , B.BUYER_ID , B.FREIGHT_TERMS FROM PS_ITM_VENDOR A , PS_VENDOR_LOC B , PS_VENDOR C WHERE A.VENDOR_SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND C.VENDOR_STATUS = 'A' AND A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ITMV_PRIORITY_LOC = B.VNDR_LOC AND %EffdtCheck(VENDOR_LOC,B,%CurrentDateIn) AND B.EFF_STATUS='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

5 ITMV_PRIORITY_LOC Character(10) VARCHAR2(10) NOT NULL Item Supplier Priority Loc
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
8 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
9 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
12 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
13 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code