EN_RTGCODE1_VW

(SQL View)
Index Back

ECF for each routing

8/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