PL_SRC_PRPOC_VW

(SQL View)
 Index Back

Production Option Controlled

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

SELECT DISTINCT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.INV_ITEM_ID , B.BOM_CODE , B.RTG_CODE , C.PRIORITY_NBR , A.MFG_MIN_ORDER , A.MFG_MAX_ORDER , A.MFG_ORDER_MULTIPLE FROM PS_PL_ITEM_ATTRIB A , PS_EN_PDO_BOM_RTG B , PS_EN_RTG_HEADER C , PS_BU_ITEMS_INV D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID AND D.MG_PRDN_OPTION = '02' AND B.INCL_IN_PLAN = 'Y' AND A.MFG_LEAD_TIME_FLAG = 'N' AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.INV_ITEM_ID = D.REF_ROUTING_ITEM AND C.RTG_STATE = 'PR' AND C.RTG_TYPE = 'PR' AND B.RTG_CODE = C.RTG_CODE

# 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_BUMGOP_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 MG_ASSOCIATED_BOM Character(18) VARCHAR2(18) NOT NULL 04/99 LAJ CN#EN800.6.0 Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).
4 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
5 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
6 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
7 MFG_MIN_ORDER Number(12,4) DECIMAL(11,4) NOT NULL CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Order 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 PL_MIN_ORDER
8 MFG_MAX_ORDER Number(12,4) DECIMAL(11,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 PL_MAX_ORDER
9 MFG_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