APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 77: ,transactional_curr_code oe_order_headers_all.transactional_curr_code%TYPE

73: ,order_line_id NUMBER
74: ,inventory_item_id NUMBER
75: ,unit_list_price NUMBER
76: ,quantity NUMBER
77: ,transactional_curr_code oe_order_headers_all.transactional_curr_code%TYPE
78: ,line_category_code oe_order_lines_all.line_category_code%TYPE
79: ,reference_line_id NUMBER
80: ,order_number NUMBER
81: ,group_nos VARCHAR2(256)

Line 180: FROM oe_order_lines_all line, oe_order_headers_all header,

176: NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)) quantity,
177: header.transactional_curr_code, line.invoice_to_org_id,
178: line.sold_to_org_id, line.ship_to_org_id,line.line_category_code, line.reference_line_id,
179: header.order_number
180: FROM oe_order_lines_all line, oe_order_headers_all header,
181: (SELECT DISTINCT eligibility_id FROM ozf_temp_eligibility) temp
182: WHERE trunc(NVL(line.pricing_date, NVL(line.actual_shipment_date, line.fulfillment_date)))
183: BETWEEN p_start_date AND p_end_date
184: AND line.booked_flag = 'Y'

Line 197: FROM oe_order_lines_all line, oe_order_headers_all header,

193: NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)) quantity,
194: header.transactional_curr_code, line.invoice_to_org_id,
195: line.sold_to_org_id, line.ship_to_org_id,line.line_category_code, line.reference_line_id,
196: header.order_number
197: FROM oe_order_lines_all line, oe_order_headers_all header,
198: (SELECT DISTINCT eligibility_id FROM ozf_temp_eligibility) temp
199: WHERE trunc(NVL(line.pricing_date, NVL(line.actual_shipment_date, line.fulfillment_date)))
200: BETWEEN p_start_date AND p_end_date
201: AND line.booked_flag = 'Y'

Line 243: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;

239: AND object_id = p_list_header_id
240: AND ROWNUM = 1;
241:
242: TYPE numberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
243: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;
244: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;
245: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
246:
247: l_headerIdTbl numberTbl;

Line 492: oe_order_headers_all header

488: SELECT cust.cust_account_id
489: FROM hz_cust_acct_sites_all acct_site,
490: hz_cust_site_uses_all site_use,
491: hz_cust_accounts cust,
492: oe_order_headers_all header
493: WHERE header.header_id = p_header_id
494: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
495: AND acct_site.cust_account_id = cust.cust_account_id
496: AND site_use.site_use_id = header.invoice_to_org_id ;

Line 534: FROM oe_order_lines_all line, oe_order_headers_all header

530:
531: -- Added for bug 7030415. get order's org_id
532: CURSOR c_order_org_id (p_line_id IN NUMBER) IS
533: SELECT header.org_id
534: FROM oe_order_lines_all line, oe_order_headers_all header
535: WHERE line_id = p_line_id
536: AND line.header_id = header.header_id;
537:
538: -- get conversion type

Line 947: oe_order_headers_all header

943: SELECT cust.cust_account_id
944: FROM hz_cust_acct_sites_all acct_site,
945: hz_cust_site_uses_all site_use,
946: hz_cust_accounts cust,
947: oe_order_headers_all header
948: WHERE header.header_id = p_header_id
949: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
950: AND acct_site.cust_account_id = cust.cust_account_id
951: AND site_use.site_use_id = header.invoice_to_org_id ;

Line 3513: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

3509: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
3510: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
3511: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
3512: ), header.transactional_curr_code
3513: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
3514: WHERE line.line_id = adj.line_id
3515: AND line.header_id = header.header_id
3516: AND line.header_id = adj.header_id
3517: AND adj.list_header_id = p_list_header_id

Line 3531: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

3527: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
3528: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
3529: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
3530: ), header.transactional_curr_code
3531: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
3532: WHERE line.line_id = adj.line_id
3533: AND line.header_id = header.header_id
3534: AND line.header_id = adj.header_id
3535: AND adj.list_header_id = p_list_header_id

Line 3756: FROM oe_order_lines_all line, oe_order_headers_all header

3752: line.actual_shipment_date,
3753: line.fulfillment_date, -- invoiced date ?????
3754: line.inventory_item_id,
3755: header.transactional_curr_code
3756: FROM oe_order_lines_all line, oe_order_headers_all header
3757: WHERE line.line_id = p_order_line_id
3758: AND line.header_id = header.header_id;
3759:
3760:

Line 4680: FROM oe_order_lines_all line, oe_order_headers_all header

4676: line.fulfillment_date, -- invoiced date ?????
4677: line.inventory_item_id,
4678: header.transactional_curr_code,
4679: header.header_id
4680: FROM oe_order_lines_all line, oe_order_headers_all header
4681: WHERE line.line_id = p_order_line_id
4682: AND line.header_id = header.header_id;
4683:
4684:

Line 4730: oe_order_headers_all header

4726: SELECT cust.cust_account_id
4727: FROM hz_cust_acct_sites_all acct_site,
4728: hz_cust_site_uses_all site_use,
4729: hz_cust_accounts cust,
4730: oe_order_headers_all header
4731: WHERE header.header_id = p_header_id
4732: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
4733: AND acct_site.cust_account_id = cust.cust_account_id
4734: AND site_use.site_use_id = header.invoice_to_org_id ;