View: MRP_AP_BOM_COMPONENTS_V

View Text

SELECT BIC.COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID INVENTORY_ITEM_ID
, BBOM.BILL_SEQUENCE_ID
, (BIC.COMPONENT_QUANTITY/BIC.COMPONENT_YIELD_FACTOR)* BIC.PLANNING_FACTOR/100.0 USAGE_QUANTITY
, BIC.COMPONENT_YIELD_FACTOR
, BIC.EFFECTIVITY_DATE
, BIC.DISABLE_DATE
, BIC.OPERATION_LEAD_TIME_PERCENT OPERATION_OFFSET_PERCENT
, BIC.OPTIONAL OPTIONAL_COMPONENT
, BIC.WIP_SUPPLY_TYPE
, BIC.PLANNING_FACTOR
, BIC.REVISED_ITEM_SEQUENCE_ID
, BIC.CHECK_ATP ATP_FLAG
, BIC.BOM_ITEM_TYPE COMPONENT_TYPE
, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_UNIT_NUMBER
, BIC.TO_END_ITEM_UNIT_NUMBER TO_UNIT_NUMBER
, ERI.STATUS_TYPE
, ERI.MRP_ACTIVE
, ERI.USE_UP USE_UP_CODE
, DECODE( NVL(ERI.STATUS_TYPE
, 6)
, 6
, NULL
, ERI.USE_UP_ITEM_ID) DRIVING_ITEM_ID
, ERI.CHANGE_NOTICE
, BBOM.ORGANIZATION_ID
, BBOM.ASSEMBLY_ITEM_ID USING_ASSEMBLY_ID
, NVL(ERI.RN
, 0) RN6
, MSIK2.RN RN5
, MSIK.RN RN4
, MP.RN RN3
, BIC.RN RN2
, BBOM.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK2
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_ERIS_SN ERI
, MRP_AP_BOMS_SN BBOM
, MRP_AP_INV_COMPS_SN BIC
WHERE MP.ORGANIZATION_ID= BBOM.ORGANIZATION_ID
AND ERI.REVISED_ITEM_SEQUENCE_ID (+)= BIC.REVISED_ITEM_SEQUENCE_ID
AND BBOM.COMMON_BILL_SEQUENCE_ID= BIC.BILL_SEQUENCE_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))
AND BIC.COMPONENT_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND BBOM.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND BBOM.ASSEMBLY_ITEM_ID = MSIK2.INVENTORY_ITEM_ID
AND BBOM.ORGANIZATION_ID = MSIK2.ORGANIZATION_ID

Columns