PL_SRC_BUY_VW

(SQL View)
 Index Back

PL Sourcing PO Opt for Buy Itm

11/15/01 EGS (CN#PL900-1): Added

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , E.PUR_MIN_ORDER , E.PUR_MAX_ORDER , E.PUR_ORDER_MULTIPLE , E.PURCHASE_YIELD , D.LEAD_TIME ,'Y' FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_ITM_CAT_TBL D , PS_PL_ITEM_ATTRIB E WHERE A.SOURCE_CODE = '2' AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.SETID = D.SETID AND B.CATEGORY_ID = D.CATEGORY_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.INV_ITEM_ID = E.INV_ITEM_ID AND E.USE_SHIPTO_LOC = 'N' AND E.USE_REGION_VNDR = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 PUR_MIN_ORDER Number(16,4) DECIMAL(15,4) NOT NULL CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Ord Qty to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PUR_MIN_ORDER2
4 PUR_MAX_ORDER Number(16,4) DECIMAL(15,4) NOT NULL jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PUR_MAX_ORDER2
5 PUR_ORDER_MULTIPLE Number(12,4) DECIMAL(11,4) NOT NULL jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
6 PURCHASE_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Purchase Yield
7 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
8 ROW_EXISTS Character(1) VARCHAR2(1) NOT NULL 12/11/01 EGS (CN#PL900-1): Added.