BUSINESS_UNITINV_ITEM_IDBOM_STATEEN=Engineering
PR=Manufacturing
BOM_TYPEPR=Production
RW=Rework
RTG_CODEEN_RTGCODE1_VW(SQL View) |
Index Back |
|---|---|
ECF for each routing8/1/02 YBO Enhancement - Record view to show Routing Code and Expected Completion Factor (ECF) based on business unit, item ID, bom state (ie routing state), and bom type (ie routing type). Used in BOM/EBOM Summarized. |
| SELECT DISTINCT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.RTG_STATE , A.RTG_TYPE , A.RTG_CODE FROM PS_EN_RTG_OPS A WHERE A.RTG_CODE = ( SELECT MIN(B.RTG_CODE) FROM PS_EN_RTG_OPS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.RTG_STATE = B.RTG_STATE AND A.RTG_TYPE = B.RTG_TYPE) |
| # | 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 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
| 4 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 5 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |