eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OE_ORDER_LINES_ALL

Line 78: ,line_category_code oe_order_lines_all.line_category_code%TYPE

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)
82: );

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 244: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;

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;
248: l_lineIdTbl numberTbl;

Line 522: FROM oe_order_lines_all

518:
519: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
520: SELECT NVL(invoiced_quantity, NVL(shipped_quantity, 0)) quantity,
521: ship_to_org_id, invoice_to_org_id
522: FROM oe_order_lines_all
523: WHERE line_id = p_order_line_id;
524:
525: l_order_org_id NUMBER;
526: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

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 899: FROM oe_order_lines_all

895: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
896: SELECT actual_shipment_date, shipped_quantity, flow_status_code, invoice_interface_status_code,
897: invoiced_quantity, sold_to_org_id, invoice_to_org_id, ship_to_org_id, shipping_quantity_uom,
898: order_quantity_uom, unit_selling_price, org_id, ordered_quantity
899: FROM oe_order_lines_all
900: WHERE line_id = p_line_id;
901:
902: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
903: SELECT cust.trx_date -- transaction(invoice) date

Line 2118: oe_order_lines_all ol,

2114: ,util.reference_id
2115: FROM ozf_funds_utilized_all_b util,
2116: ozf_temp_eligibility temp,
2117: ozf_offer_adjustment_lines adjl,
2118: oe_order_lines_all ol,
2119: oe_price_adjustments oe
2120: WHERE util.plan_type = 'OFFR'
2121: AND product_id IS NOT NULL
2122: AND util.plan_id = p_qp_list_header_id

Line 2244: oe_order_lines_all ol,

2240: ,util.reference_id
2241: FROM ozf_funds_utilized_all_b util,
2242: ozf_temp_eligibility temp,
2243: ozf_offer_adjustment_lines adjl,
2244: oe_order_lines_all ol,
2245: oe_price_adjustments oe
2246: WHERE util.plan_type = 'OFFR'
2247: AND product_id IS NOT NULL
2248: AND util.plan_id = p_qp_list_header_id

Line 2333: oe_order_lines_all ol,

2329: ,util.reference_id
2330: FROM ozf_funds_utilized_all_b util,
2331: ozf_temp_eligibility temp,
2332: ozf_offer_adjustment_lines adjl,
2333: oe_order_lines_all ol,
2334: oe_price_adjustments oe
2335: WHERE util.plan_type = 'OFFR'
2336: AND product_id IS NOT NULL
2337: AND util.plan_id = p_qp_list_header_id

Line 2415: oe_order_lines_all ol,

2411: ,util.reference_type
2412: ,util.reference_id
2413: FROM ozf_funds_utilized_all_b util,
2414: ozf_offer_adjustment_lines adjl,
2415: oe_order_lines_all ol,
2416: oe_price_adjustments oe
2417: WHERE util.plan_type = 'OFFR'
2418: AND util.plan_id = p_qp_list_header_id
2419: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id

Line 2463: oe_order_lines_all ol,

2459: ,util.reference_id
2460: FROM ozf_funds_utilized_all_b util,
2461: ozf_temp_eligibility temp,
2462: ozf_offer_adjustment_lines adjl,
2463: oe_order_lines_all ol,
2464: oe_price_adjustments oe
2465: WHERE util.plan_type = 'OFFR'
2466: AND product_id IS NOT NULL
2467: AND util.plan_id = p_qp_list_header_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 4577: FROM oe_order_lines_all line

4573:
4574: /* CURSOR c_order_line_qty(p_order_line_id IN NUMBER) IS
4575: SELECT DECODE(line.line_category_code,'ORDER',line.ordered_quantity,
4576: 'RETURN', -line.ordered_quantity) ordered_quantity
4577: FROM oe_order_lines_all line
4578: WHERE line.line_id = p_order_line_id;*/
4579:
4580:
4581: /* CURSOR c_all_orders (p_list_header_id IN NUMBER) IS

Line 4584: select sum(ordered_quantity) ordered_quantity from oe_order_lines_all

4580:
4581: /* CURSOR c_all_orders (p_list_header_id IN NUMBER) IS
4582: select sum(ordered_quantity)
4583: FROM (
4584: select sum(ordered_quantity) ordered_quantity from oe_order_lines_all
4585: where line_id IN
4586: (SELECT order_line_id FROM ozf_funds_utilized_all_b
4587: WHERE plan_id = p_list_header_id
4588: AND plan_type = 'OFFR'

Line 4609: from oe_order_lines_all oe,

4605: select sum(ordered_quantity)
4606: FROM (
4607: SELECT SUM(DECODE(line_category_code,'ORDER',ordered_quantity,
4608: 'RETURN', -ordered_quantity)) ordered_quantity
4609: from oe_order_lines_all oe,
4610: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
4611: WHERE plan_id = p_list_header_id
4612: AND plan_type = 'OFFR'
4613: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

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 4722: FROM oe_order_lines_all

4718: WHERE qp_list_header_id = p_list_header_id;
4719:
4720: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
4721: SELECT invoice_to_org_id, ship_to_org_id
4722: FROM oe_order_lines_all
4723: WHERE line_id = p_line_id;
4724:
4725: CURSOR c_cust_number (p_header_id IN NUMBER) IS
4726: SELECT cust.cust_account_id

Line 4765: from oe_order_lines_all oe,

4761: select sum(ordered_quantity)
4762: FROM (
4763: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
4764: 'RETURN', -ordered_quantity)) ordered_quantity
4765: from oe_order_lines_all oe,
4766: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
4767: WHERE plan_id = p_list_header_id
4768: AND plan_type = 'OFFR'
4769: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

Line 4793: from oe_order_lines_all oe,

4789: select sum(ordered_quantity)
4790: FROM (
4791: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
4792: 'RETURN', -ordered_quantity)) ordered_quantity
4793: from oe_order_lines_all oe,
4794: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
4795: WHERE plan_id = p_list_header_id
4796: AND plan_type = 'OFFR'
4797: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')