PL_BOM_COMPS_VW(SQL View) |
Index Back |
|---|---|
Planning BOM Component ViewPlanning BOM Component View |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , B.OP_SEQUENCE , B.COMPONENT_ID , B.DATE_IN_EFFECT , B.DATE_OBSOLETE , C.PHANTOM_ITEM_FLAG , B.QTY_CODE , B.QTY_PER , B.YIELD , A.BOM_QTY , B.TEARDOWN_FLAG , A.BOM_CODE FROM PS_EN_BOM_HEADER A , PS_EN_BOM_COMPS B , PS_BU_ITEMS_INV C , PS_PL_ITEM_ATTRIB D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BOM_STATE = B.BOM_STATE AND A.BOM_TYPE = B.BOM_TYPE AND A.BOM_CODE = B.BOM_CODE AND A.BOM_STATE = 'PR' AND A.BOM_TYPE = 'PR' AND B.SUB_SUPPLY_FLG = 'N' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.INV_ITEM_ID = B.COMPONENT_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.INV_ITEM_ID = B.COMPONENT_ID AND (D.PLANNED_BY = '2' OR D.PLANNED_BY = '3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 5 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 6 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 7 | PHANTOM_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Phantom Item |
| 8 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 9 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 10 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 11 | BOM_QTY | Number(7,0) | INTEGER NOT NULL | 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard. |
| 12 | TEARDOWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 01/28/99 jnw (CN#SF800-13) added field |
| 13 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |