APPS.WMS_RULES_WORKBENCH_PVT dependencies on WSH_DELIVERY_DETAILS

Line 1645: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id

1641:
1642: -- MOAC : changed oe_order_headers to oe_order_headers_all
1643:
1644: /* added the index hint with the suggestion of apps performance team */
1645: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1646: from oe_order_headers_all oh,
1647: wsh_delivery_details wdd
1648: where oh.header_id = wdd.source_header_id
1649: and wdd.released_status = 'S'

Line 1647: wsh_delivery_details wdd

1643:
1644: /* added the index hint with the suggestion of apps performance team */
1645: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1646: from oe_order_headers_all oh,
1647: wsh_delivery_details wdd
1648: where oh.header_id = wdd.source_header_id
1649: and wdd.released_status = 'S'
1650: and wdd.source_code = 'OE'
1651: and wdd.move_order_line_id = p_move_order_line_id;