BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
INV_ITEM_IDBOM_CODERTG_CODEPL_SRC_PRBRA_VW(SQL View) |
Index Back |
|---|---|
Prdn Options w/ Associated Bom11/27/01 EGS (CN#PL900-1): Added. |
| SELECT AA.BUSINESS_UNIT , AA.INV_ITEM_ID , AA.MG_ASSOCIATED_BOM , B.RTG_CODE , C.BOM_CODE , B.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_RTG_HEADER B , PS_EN_BOM_HEADER C , PS_BU_ITEMS_INV D , PS_PL_ITEM_ATTRIB 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 D.BUSINESS_UNIT = AA.BUSINESS_UNIT AND D.INV_ITEM_ID = AA.MG_ASSOCIATED_BOM AND D.ITM_STATUS_CURRENT < '4' AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.INV_ITEM_ID = E.INV_ITEM_ID AND D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.REF_ROUTING_ITEM = B.INV_ITEM_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.INV_ITEM_ID = C.INV_ITEM_ID AND B.COPY_TO_PLANNING = 'Y' AND B.RTG_TYPE = 'PR' AND B.RTG_STATE = 'PR' AND C.BOM_STATE = 'PR' AND C.BOM_TYPE = 'PR' AND D.MG_PRDN_OPTION = '01' AND E.MFG_LEAD_TIME_FLAG = 'N' AND (D.RTG_CODE = 0 OR B.RTG_CODE = D.RTG_CODE) AND (D.BOM_CODE = 0 OR C.BOM_CODE = D.BOM_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 |