APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_RESERVATIONS

Line 1588: select /*+ leading(wdct) index(mr MTL_RESERVATIONS_N9) */ -- otimizacao

1584: WHERE wdct.organization_id = p_organization_id
1585: AND wdct.group_id = p_group_id
1586: AND wdct.wip_entity_id = wrv.wip_entity_id;
1587: */
1588: select /*+ leading(wdct) index(mr MTL_RESERVATIONS_N9) */ -- otimizacao
1589: mr.reservation_id
1590: from
1591: wip_dj_close_temp wdct, -- otimizacao
1592: mtl_reservations mr, -- otimizacao

Line 1592: mtl_reservations mr, -- otimizacao

1588: select /*+ leading(wdct) index(mr MTL_RESERVATIONS_N9) */ -- otimizacao
1589: mr.reservation_id
1590: from
1591: wip_dj_close_temp wdct, -- otimizacao
1592: mtl_reservations mr, -- otimizacao
1593: mtl_sales_orders mso, -- otimizacao
1594: oe_order_lines_all ool -- otimizacao
1595: where ((wdct.organization_id= p_organization_id and wdct.group_id= p_group_id)
1596: and mr.supply_source_header_id=wdct.wip_entity_id)