EN_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 |