APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on BOM_OPERATIONAL_ROUTINGS

Line 160: BOM_OPERATIONAL_ROUTINGS ROUT,

156: BOM_DEPARTMENTS BD,
157: BOM_RESOURCES BR,
158: CST_ACTIVITIES CA,
159: BOM_OPERATION_SEQUENCES BOS,
160: BOM_OPERATIONAL_ROUTINGS ROUT,
161: mtl_material_transactions_temp MMTT
162: WHERE
163: MMTT.transaction_temp_id = p_txn_temp_id
164: AND MMTT.inventory_item_id = p_phantom_item_id

Line 344: BOM_OPERATIONAL_ROUTINGS BOR,

340: FROM
341: BOM_DEPARTMENTS bd,
342: BOM_OPERATION_SEQUENCES bos,
343: WIP_FLOW_SCHEDULES wfs,
344: BOM_OPERATIONAL_ROUTINGS BOR,
345: mtl_material_transactions_temp mmtt
346: WHERE
347: MMTT.transaction_temp_id = p_txn_temp_id
348: AND MMTT.transaction_source_id = wfs.wip_entity_id

Line 513: BOM_OPERATIONAL_ROUTINGS BOR,

509: FROM
510: BOM_DEPARTMENTS bd,
511: BOM_OPERATION_SEQUENCES bos,
512: WIP_flow_schedules wfs,
513: BOM_OPERATIONAL_ROUTINGS BOR,
514: mtl_material_transactions_temp mmtt
515: WHERE
516: MMTT.transaction_temp_id = p_txn_temp_id
517: AND MMTT.transaction_source_id = wfs.wip_entity_id

Line 615: BOM_OPERATIONAL_ROUTINGS BRTG,

611: BOM_OPERATION_RESOURCES BOR,
612: BOM_DEPARTMENT_RESOURCES BDR1,
613: BOM_DEPARTMENT_RESOURCES BDR2,
614: BOM_OPERATION_SEQUENCES BOS,
615: BOM_OPERATIONAL_ROUTINGS BRTG,
616: MTL_SYSTEM_ITEMS msi
617: WHERE
618: BRTG.organization_id = p_org_id
619: and BRTG.assembly_item_id = p_phantom_item_id

Line 644: FROM BOM_OPERATIONAL_ROUTINGS BOR,BOM_OPERATION_SEQUENCES BOS

640:
641:
642: CURSOR c_explodephantom IS
643: SELECT bos.operation_sequence_id
644: FROM BOM_OPERATIONAL_ROUTINGS BOR,BOM_OPERATION_SEQUENCES BOS
645: WHERE bor.organization_id=p_org_id
646: AND bor.assembly_item_id= p_phantom_item_id
647: AND bos.routing_sequence_id=bor.routing_sequence_id
648: AND bor.alternate_routing_designator IS NULL