BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
INV_ITEM_IDBOM_CODERTG_CODEPL_SRC_PRBR_VW(SQL View) |
Index Back |
|---|---|
Production Options11/27/01 EGS (CN#PL900-1): Added. |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.INV_ITEM_ID , C.BOM_CODE , B.RTG_CODE , B.PRIORITY_NBR , D.MFG_MIN_ORDER , D.MFG_MAX_ORDER , D.MFG_ORDER_MULTIPLE FROM PS_BU_ITEMS_INV A , PS_EN_RTG_HEADER B , PS_EN_BOM_HEADER C , PS_PL_ITEM_ATTRIB D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REF_ROUTING_ITEM = B.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 A.MG_PRDN_OPTION = '01' AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.INV_ITEM_ID = A.INV_ITEM_ID AND D.MFG_LEAD_TIME_FLAG = 'N' AND (A.BOM_CODE = 0 OR A.BOM_CODE = C.BOM_CODE) AND (A.RTG_CODE = 0 OR A.RTG_CODE = B.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 |