APPS.WMS_RULES_WORKBENCH_PVT dependencies on WSH_DELIVERY_DETAILS

Line 751: FROM wsh_delivery_details wdd,

747: (p_type_code=1 AND mtrl.put_away_strategy_id IS NULL) ) /*10371674*/
748: ) mtrl1
749: WHERE ( NVL(l_freight_code,'AAA') = 'AAA' OR
750: EXISTS (SELECT 1
751: FROM wsh_delivery_details wdd,
752: wsh_carriers wc,
753: wsh_carrier_services wcs
754: WHERE wdd.move_order_line_id = mtrl1.line_id
755: AND wdd.ship_method_code = wcs.ship_method_code (+)

Line 761: EXISTS (SELECT 1 FROM wsh_delivery_details wdd

757: AND wc.freight_code = l_freight_code
758: )
759: )
760: AND ( Nvl(l_customer_id, -999) = -999 OR
761: EXISTS (SELECT 1 FROM wsh_delivery_details wdd
762: WHERE wdd.move_order_line_id = mtrl1.line_id
763: AND wdd.customer_id = l_customer_id
764: )
765: )

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

1887:
1888: -- MOAC : changed oe_order_headers to oe_order_headers_all
1889:
1890: /* added the index hint with the suggestion of apps performance team */
1891: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1892: from oe_order_headers_all oh,
1893: wsh_delivery_details wdd
1894: where oh.header_id = wdd.source_header_id
1895: and wdd.released_status = 'S'

Line 1893: wsh_delivery_details wdd

1889:
1890: /* added the index hint with the suggestion of apps performance team */
1891: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1892: from oe_order_headers_all oh,
1893: wsh_delivery_details wdd
1894: where oh.header_id = wdd.source_header_id
1895: and wdd.released_status = 'S'
1896: and wdd.source_code = 'OE'
1897: and wdd.move_order_line_id = p_move_order_line_id;

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

1941:
1942: -- MOAC : changed oe_order_headers to oe_order_headers_all
1943:
1944: /* added the index hint with the suggestion of apps performance team */
1945: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1946: from oe_order_headers_all oh,
1947: wsh_delivery_details wdd
1948: where oh.header_id = wdd.source_header_id
1949: and wdd.released_status = 'S'

Line 1947: wsh_delivery_details wdd

1943:
1944: /* added the index hint with the suggestion of apps performance team */
1945: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1946: from oe_order_headers_all oh,
1947: wsh_delivery_details wdd
1948: where oh.header_id = wdd.source_header_id
1949: and wdd.released_status = 'S'
1950: and wdd.source_code = 'OE'
1951: and wdd.move_order_line_id = p_move_order_line_id;