BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
INV_ITEM_IDBOM_CODERTG_CODEPL_SRC_PRLTA_VW(SQL View) |
Index Back |
|---|---|
Lead Time Controlled Prdn Opt11/27/01 EGS (CN#PL900-1): Added. |
| SELECT AA.BUSINESS_UNIT , AA.INV_ITEM_ID , AA.MG_ASSOCIATED_BOM , B.BOM_CODE , 0 , 0 , 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_BOM_HEADER B , PS_BU_ITEMS_INV C , PS_PL_ITEM_ATTRIB D 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 = AA.BUSINESS_UNIT AND B.INV_ITEM_ID = AA.MG_ASSOCIATED_BOM AND B.BOM_STATE = 'PR' AND B.BOM_TYPE = 'PR' AND D.BUSINESS_UNIT = AA.BUSINESS_UNIT AND D.INV_ITEM_ID = AA.MG_ASSOCIATED_BOM AND D.MFG_LEAD_TIME_FLAG = 'Y' AND C.BUSINESS_UNIT = AA.BUSINESS_UNIT AND C.INV_ITEM_ID = AA.MG_ASSOCIATED_BOM AND C.ITM_STATUS_CURRENT < '4' AND (C.BOM_CODE = 0 OR C.BOM_CODE = B.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 |