Product: | CSD - Depot Repair |
---|---|
Description: | View that displays the mapping between Service Codes and BOM and Routings. |
Implementation/DBA Data: | APPS.CSD_SC_BOM_AND_ROUTE_V |
SELECT CSCWE.ROWID
, CSCWE.SC_WORK_ENTITY_ID
, CSCWE.OBJECT_VERSION_NUMBER
, CSCWE.SERVICE_CODE_ID
, CSCWE.CREATED_BY
, CSCWE.CREATION_DATE
, CSCWE.LAST_UPDATED_BY
, CSCWE.LAST_UPDATE_DATE
, CSCWE.LAST_UPDATE_LOGIN
, CSCWE.WORK_ENTITY_ID3 ORGANIZATION_ID
, MTL.ORGANIZATION_CODE
, HR.NAME
, CSCWE.WORK_ENTITY_ID1 BOM_SEQUENCE_ID
, BOM.ASSEMBLY_ITEM_ID BOM_ITEM_ID
, MSIB.CONCATENATED_SEGMENTS BOM_ITEM_NAME
, MSIB.DESCRIPTION BOM_ITEM_DESC
, BOM.ALTERNATE_BOM_DESIGNATOR
, ALTB.DESCRIPTION ALTERNATE_BOM_DESC
, CSCWE.WORK_ENTITY_ID2 ROUTING_SEQUENCE_ID
, BOR.ASSEMBLY_ITEM_ID ROUTING_ITEM_ID
, MSIR.CONCATENATED_SEGMENTS ROUTING_ITEM_NAME
, MSIR.DESCRIPTION ROUTING_ITEM_DESC
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, ALTR.DESCRIPTION ALTERNATE_ROUTING_DESC
FROM CSD_SC_WORK_ENTITIES CSCWE
, BOM_BILL_OF_MATERIALS BOM
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_ALTERNATE_DESIGNATORS ALTB
, BOM_ALTERNATE_DESIGNATORS ALTR
, MTL_SYSTEM_ITEMS_KFV MSIB
, MTL_SYSTEM_ITEMS_KFV MSIR
, MTL_PARAMETERS MTL
, HR_ALL_ORGANIZATION_UNITS HR
WHERE CSCWE.WORK_ENTITY_TYPE_CODE = 'BOM'
AND CSCWE.WORK_ENTITY_ID3 = MTL.ORGANIZATION_ID
AND MTL.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CSCWE.WORK_ENTITY_ID1 = BOM.BILL_SEQUENCE_ID (+)
AND CSCWE.WORK_ENTITY_ID2 = BOR.ROUTING_SEQUENCE_ID (+)
AND BOM.ASSEMBLY_ITEM_ID = MSIB.INVENTORY_ITEM_ID (+)
AND BOR.ASSEMBLY_ITEM_ID = MSIR.INVENTORY_ITEM_ID (+)
AND BOM.ALTERNATE_BOM_DESIGNATOR = ALTB.ALTERNATE_DESIGNATOR_CODE (+)
AND BOM.ORGANIZATION_ID = ALTB.ORGANIZATION_ID (+)
AND BOR.ALTERNATE_ROUTING_DESIGNATOR = ALTR.ALTERNATE_DESIGNATOR_CODE (+)
AND BOR.ORGANIZATION_ID = ALTR.ORGANIZATION_ID (+)
AND BOM.ORGANIZATION_ID = MSIB.ORGANIZATION_ID (+)
AND BOR.ORGANIZATION_ID = MSIR.ORGANIZATION_ID (+)