DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on MTL_RESERVATIONS

Line 1655: from mtl_reservations mr

1651: where fad.entity_name = 'OE_ORDER_HEADERS'
1652: and pk1_value IN ( select header_id
1653: from oe_order_lines_all
1654: where line_id in ( select mr.demand_source_line_id
1655: from mtl_reservations mr
1656: where mr.demand_source_type_id in (2,8)
1657: and mr.supply_source_type_id = 5
1658: and mr.supply_source_header_id = p_job_id
1659: and mr.organization_id = p_org_id ))

Line 1675: from mtl_reservations mr

1671: where exists (select 1
1672: from FND_ATTACHED_DOCUMENTS fad
1673: where fad.entity_name = 'OE_ORDER_LINES'
1674: and pk1_value IN ( select mr.demand_source_line_id
1675: from mtl_reservations mr
1676: where mr.demand_source_type_id in (2,8)
1677: and mr.supply_source_type_id = 5
1678: and mr.supply_source_header_id = p_job_id
1679: and mr.organization_id = p_org_id )