DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on BOM_OPERATIONAL_ROUTINGS

Line 101: FROM mtl_transactions_interface mti, bom_operational_routings bor

97:
98: begin
99: SELECT mti.routing_revision_date, bor.routing_sequence_id -- CFM Scrap
100: INTO x_rout_rev_date, x_rout_seq_id
101: FROM mtl_transactions_interface mti, bom_operational_routings bor
102: WHERE mti.transaction_interface_id = p_parent_id
103: AND mti.inventory_item_id = bor.assembly_item_id(+)
104: AND mti.organization_id = bor.organization_id(+)
105: AND Nvl(mti.alternate_routing_designator,'@@@@') = Nvl(bor.alternate_routing_designator,'@@@@');