DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 530: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L

526:
527: --
528: SELECT SUM(NVL(L.ORDERED_QUANTITY, 0) * NVL(L.UNIT_SELLING_PRICE, 0))
529: INTO l_order_value
530: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L
531: WHERE H.HEADER_ID = p_header_id
532: and l.line_id = p_line_id
533: AND L.HEADER_ID = H.HEADER_ID;
534:

Line 11282: FROM wms_wp_Wave_lines wwl, oe_order_headers_all ooh, wsh_delivery_details wdd --11775489 get from wdd... FIXED...check performance problem

11278: max(ooh.conversion_rate) conversion_rate,
11279: max(ooh.conversion_type_code) conversion_type_code,
11280: max(ooh.conversion_rate_Date) conversion_rate_Date
11281: --max(org_id) org_id 12371804 remove this
11282: FROM wms_wp_Wave_lines wwl, oe_order_headers_all ooh, wsh_delivery_details wdd --11775489 get from wdd... FIXED...check performance problem
11283: WHERE wwl.wave_header_id = p_wave_header_id
11284: and wwl.delivery_detail_id = wdd.delivery_detail_id
11285: and wdd.organization_id = wwl.organization_id
11286: AND wdd.source_header_number = ooh.order_number

Line 13171: ',oe_order_headers_all OOHA ';

13167: elsif cur_rec.parameter_id IN (1011, 1004) then
13168: -- Ship Method, Carrier, Scheduled Ship Date
13169: if v_carrier_order_flag = 'N' then
13170: g_Unreleased_SQL := g_Unreleased_SQL ||
13171: ',oe_order_headers_all OOHA ';
13172: g_WHERE_SQL := g_WHERE_SQL ||
13173: ' WDD.source_header_id=OOHA.header_id AND ';
13174: end if;
13175: v_carrier_order_flag := 'Y';

Line 17933: from oe_order_headers_all ooh,

17929: ooh.CUST_PO_NUMBER,
17930: ooh.ordered_date,
17931: ooh.request_date order_request_date,
17932: wl.order_progress
17933: from oe_order_headers_all ooh,
17934: HZ_PARTIES HP,
17935: hz_cust_accounts CUST_ACCT,
17936: oe_transaction_types_tl ott,
17937: (select wwlv.source_header_id,