EN_CST_RTG_VW

(SQL View)
 Index Back

Costed Routing Header View

CN#MG880-YBO dbe

SELECT DISTINCT A.BUSINESS_UNIT , INV.INV_ITEM_ID , A.RTG_TYPE , A.RTG_STATE , A.INV_ITEM_ID , B.DESCR FROM PS_EN_RTG_HEADER A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_BU_ITEMS_INV INV WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT=INV.BUSINESS_UNIT AND A.INV_ITEM_ID= ( SELECT INV2.REF_ROUTING_ITEM FROM PS_BU_ITEMS_INV INV2 WHERE INV2.BUSINESS_UNIT=INV.BUSINESS_UNIT AND INV2.INV_ITEM_ID= ( SELECT INV3.MG_ASSOCIATED_BOM FROM PS_BU_ITEMS_INV INV3 WHERE INV3.BUSINESS_UNIT=INV.BUSINESS_UNIT AND INV3.INV_ITEM_ID=INV.MG_ASSOCIATED_BOM))

# 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 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown
4 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing
5 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description