View: MRP_AP_COMPONENT_SUBSTITUTES_V

View Text

SELECT BBOM.BILL_SEQUENCE_ID
, BSC.COMPONENT_SEQUENCE_ID
, BSC.SUBSTITUTE_COMPONENT_ID SUBSTITUTE_ITEM_ID
, BSC.SUBSTITUTE_ITEM_QUANTITY USAGE_QUANTITY
, BBOM.ORGANIZATION_ID
, MP.RN RN6
, MSIK2.RN RN5
, MSIK.RN RN4
, BBOM.RN RN3
, BIC.RN RN2
, BSC.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK2
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_BOMS_SN BBOM
, MRP_AP_INV_COMPS_SN BIC
, MRP_AP_SUB_COMPS_SN BSC
WHERE BBOM.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND BIC.COMPONENT_SEQUENCE_ID=BSC.COMPONENT_SEQUENCE_ID
AND BBOM.BILL_SEQUENCE_ID= BIC.BILL_SEQUENCE_ID
AND MSIK.ORGANIZATION_ID = BBOM.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID= BSC.SUBSTITUTE_COMPONENT_ID
AND MSIK2.ORGANIZATION_ID= BBOM.ORGANIZATION_ID
AND MSIK2.INVENTORY_ITEM_ID= BBOM.ASSEMBLY_ITEM_ID
AND ( ( MSIK2.BOM_ITEM_TYPE = 4
AND BIC.BOM_ITEM_TYPE NOT IN ( 1
, 2)) OR MSIK2.BOM_ITEM_TYPE IN ( 1
, 2
, 5))

Columns