View: WIP_EXPLOSIONS_V

Product:	WIP - Work in Process
Description:	WIP explosion information
Implementation/DBA Data:	APPS.WIP_EXPLOSIONS_V

View Text

SELECT BE.ROWID ROW_ID
, BE.OPERATION_SEQ_NUM
, BOS.OPERATION_SEQ_NUM LINE_OP
, BSO.OPERATION_CODE LINE_OP_CODE
, MSIK.CONCATENATED_SEGMENTS COMPONENT
, BE.COMPONENT_ITEM_ID
, MSIK.DESCRIPTION COMPONENT_DESCRIPTION
, BE.COMPONENT_QUANTITY / DECODE(BIC.COMPONENT_YIELD_FACTOR
, 0
, 1
, BIC.COMPONENT_YIELD_FACTOR) COMPONENT_QUANTITY
, NVL(BIC.SUPPLY_SUBINVENTORY
, MSIK.WIP_SUPPLY_SUBINVENTORY) SUPPLY_SUBINVENTORY
, DECODE(BIC.SUPPLY_SUBINVENTORY
, NULL
, MSIK.WIP_SUPPLY_LOCATOR_ID
, BIC.SUPPLY_LOCATOR_ID) SUPPLY_LOCATOR_ID
, BIC.WIP_SUPPLY_TYPE
, BE.COMPONENT_CODE
, MSIK.MTL_TRANSACTIONS_ENABLED_FLAG
, MSIK.PRIMARY_UOM_CODE
, MSIK.REVISION_QTY_CONTROL_CODE
, BE.TOP_BILL_SEQUENCE_ID
, BE.TOP_ITEM_ID
, BE.ORGANIZATION_ID
, BE.EFFECTIVITY_DATE
, BE.DISABLE_DATE
, BOR.ALTERNATE_ROUTING_DESIGNATOR
FROM BOM_EXPLOSIONS BE
, BOM_INVENTORY_COMPONENTS BIC
, MTL_SYSTEM_ITEMS_KFV MSIK
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_STANDARD_OPERATIONS BSO
WHERE BE.EXPLOSION_TYPE = 'ALL'
AND BE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BE.COMPONENT_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND BE.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND BE.COMPONENT_QUANTITY > 0
AND BOR.ORGANIZATION_ID = BE.ORGANIZATION_ID
AND BOR.ASSEMBLY_ITEM_ID = BE.TOP_ITEM_ID
AND BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
AND BE.OPERATION_SEQ_NUM = (SELECT BOS2.OPERATION_SEQ_NUM
FROM BOM_OPERATION_SEQUENCES BOS2
WHERE BOS2.LINE_OP_SEQ_ID = BOS.OPERATION_SEQUENCE_ID
AND BOS.ROUTING_SEQUENCE_ID = BOS2.ROUTING_SEQUENCE_ID
AND BOS2.OPERATION_SEQ_NUM = BE.OPERATION_SEQ_NUM)
AND BSO.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
AND BSO.ORGANIZATION_ID = BE.ORGANIZATION_ID ORDER BY BE.COMPONENT_CODE

Columns