PL_SRC_PRPOA_VW (SQL View)	Index Back
Prdn Opt Control w/ Assoc Bom 11/27/01 EGS (CN#PL900-1): Added.

PL_SRC_PRPOA_VW

(SQL View)

Prdn Opt Control w/ Assoc Bom

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

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

# 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

#	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