VIEW: APPS.WIP_EXPLOSIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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