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 OZF_FUNDS_UTILIZED_ALL_B

Line 63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;

59: g_debug_flag VARCHAR2 (1) := 'N';
60: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
61: g_bulk_limit CONSTANT NUMBER := 5000;
62:
63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;

Line 64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;

60: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
61: g_bulk_limit CONSTANT NUMBER := 5000;
62:
63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;

Line 65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;

61: g_bulk_limit CONSTANT NUMBER := 5000;
62:
63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;

Line 66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;

62:
63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415

Line 67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;

63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
71:

Line 68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;

64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
71:
72: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER

Line 69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;

65: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
71:
72: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER
73: ,order_line_id NUMBER

Line 70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415

66: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
67: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
68: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
69: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
70: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
71:
72: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER
73: ,order_line_id NUMBER
74: ,inventory_item_id NUMBER

Line 500: FROM ozf_funds_utilized_all_b

496: AND site_use.site_use_id = header.invoice_to_org_id ;
497:
498: CURSOR c_order_adjustment_amt (p_object_id IN NUMBER, p_order_line_id IN NUMBER, p_prod_id IN NUMBER) IS
499: SELECT SUM(amount)
500: FROM ozf_funds_utilized_all_b
501: WHERE plan_type = 'OFFR'
502: AND plan_id = p_list_header_id
503: AND object_type = 'ORDER'
504: AND object_id = p_object_id

Line 513: FROM ozf_funds_utilized_all_b

509: --AND utilization_type = 'ADJUSTMENT';
510:
511: CURSOR c_orig_order_adj_amt (p_order_line_id IN NUMBER) IS
512: SELECT SUM(amount)
513: FROM ozf_funds_utilized_all_b
514: WHERE plan_type = 'OFFR'
515: AND plan_id = p_list_header_id
516: AND order_line_id = p_order_line_id
517: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');

Line 931: FROM ozf_funds_utilized_all_b

927: AND source_code = 'OM');
928:
929: CURSOR c_adjustment_exists (p_list_header_id IN NUMBER, p_order_line_id IN NUMBER) IS
930: SELECT 1
931: FROM ozf_funds_utilized_all_b
932: WHERE plan_id = p_list_header_id
933: AND plan_type = 'OFFR'
934: AND order_line_id = p_order_line_id;
935:

Line 1012: FROM ozf_funds_utilized_all_b

1008:
1009:
1010: CURSOR c_order_adjustment_amt (p_object_id IN NUMBER, p_order_line_id IN NUMBER, p_prod_id IN NUMBER) IS
1011: SELECT SUM(amount)
1012: FROM ozf_funds_utilized_all_b
1013: WHERE plan_type = 'OFFR'
1014: AND plan_id = p_list_header_id
1015: AND object_type = 'ORDER'
1016: AND object_id = p_object_id

Line 1026: FROM ozf_funds_utilized_all_b

1022:
1023:
1024: CURSOR c_order_adj_amount ( p_prod_id IN NUMBER) IS
1025: SELECT SUM(amount)
1026: FROM ozf_funds_utilized_all_b
1027: WHERE plan_type = 'OFFR'
1028: AND plan_id = p_list_header_id
1029: AND object_type = 'ORDER'
1030: -- AND object_id = p_object_id

Line 2087: --for all cursors and added it to index OZF_FUNDS_UTILIZED_ALL_B_N24 to decrease the cost

2083: l_to_date DATE := p_to_date + 0.99999;
2084: l_org_id NUMBER; -- := TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)) ;
2085:
2086: --kpatro 31-JUL-2006 bug 5375224 SQL ID# 19125146 - removed trunc from adjustment_date
2087: --for all cursors and added it to index OZF_FUNDS_UTILIZED_ALL_B_N24 to decrease the cost
2088: --and shared memory of the queries
2089: CURSOR c_bdadj_all_types IS
2090: SELECT util.utilization_id,
2091: util.object_type,

Line 2115: FROM ozf_funds_utilized_all_b util,

2111: ,util.ship_to_site_use_id
2112: ,util.bill_to_site_use_id
2113: ,util.reference_type
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

Line 2163: FROM ozf_funds_utilized_all_b util,

2159: ,util.ship_to_site_use_id
2160: ,util.bill_to_site_use_id
2161: ,util.reference_type
2162: ,util.reference_id
2163: FROM ozf_funds_utilized_all_b util,
2164: ozf_temp_eligibility temp,
2165: ozf_offer_adjustment_lines adjl,
2166: OZF_RESALE_ADJUSTMENTS_ALL oe
2167: WHERE util.plan_type = 'OFFR'

Line 2197: FROM ozf_funds_utilized_all_b util,

2193: DECODE (oe.arithmetic_operator,
2194: 'NEWPRICE', ((oe.operand - adjl.modified_discount) * amount /-oe.adjusted_amount_per_pqty),
2195: ((adjl.modified_discount - oe.operand) * amount / oe.operand)
2196: ) amount
2197: FROM ozf_funds_utilized_all_b util,
2198: oe_price_adj_assocs assocs,
2199: oe_price_adjustments oe,
2200: ozf_offer_adjustment_lines adjl,
2201: ozf_temp_eligibility temp

Line 2241: FROM ozf_funds_utilized_all_b util,

2237: ,util.ship_to_site_use_id
2238: ,util.bill_to_site_use_id
2239: ,util.reference_type
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

Line 2287: FROM ozf_funds_utilized_all_b util,

2283: ,util.ship_to_site_use_id
2284: ,util.bill_to_site_use_id
2285: ,util.reference_type
2286: ,util.reference_id
2287: FROM ozf_funds_utilized_all_b util,
2288: ozf_temp_eligibility temp,
2289: ozf_offer_adjustment_lines adjl,
2290: OZF_RESALE_ADJUSTMENTS_ALL oe
2291: WHERE util.plan_type = 'OFFR'

Line 2330: FROM ozf_funds_utilized_all_b util,

2326: ,util.ship_to_site_use_id
2327: ,util.bill_to_site_use_id
2328: ,util.reference_type
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

Line 2377: FROM ozf_funds_utilized_all_b util,

2373: ,util.ship_to_site_use_id
2374: ,util.bill_to_site_use_id
2375: ,util.reference_type
2376: ,util.reference_id
2377: FROM ozf_funds_utilized_all_b util,
2378: ozf_temp_eligibility temp,
2379: ozf_offer_adjustment_lines adjl,
2380: OZF_RESALE_ADJUSTMENTS_ALL oe
2381: WHERE util.plan_type = 'OFFR'

Line 2413: FROM ozf_funds_utilized_all_b util,

2409: ,util.ship_to_site_use_id
2410: ,util.bill_to_site_use_id
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'

Line 2460: FROM ozf_funds_utilized_all_b util,

2456: ,util.ship_to_site_use_id
2457: ,util.bill_to_site_use_id
2458: ,util.reference_type
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

Line 2520: FROM ozf_funds_utilized_all_b

2516:
2517: -- added by feliu to fix bug 4451500 and 4015372.
2518: CURSOR c_adj_amount(p_utilization_id IN NUMBER) IS
2519: SELECT sum(amount) adj_amt
2520: FROM ozf_funds_utilized_all_b
2521: --12/16/2005 changed by Feng
2522: WHERE orig_utilization_id = p_utilization_id
2523: --WHERE price_adjustment_id = p_price_adj_id
2524: --AND fund_id = p_fund_id

Line 2532: FROM ozf_funds_utilized_all_b

2528:
2529: --Added for bugfix 6278466
2530: CURSOR c_org_id (p_utilization_id IN NUMBER) IS
2531: SELECT org_id
2532: FROM ozf_funds_utilized_all_b
2533: WHERE utilization_id = p_utilization_id;
2534:
2535: l_offer_info c_offer_info%ROWTYPE;
2536: l_index NUMBER := 1;

Line 3118: FROM ozf_funds_utilized_all_b

3114: */
3115: CURSOR c_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2,p_order_line_id IN NUMBER) IS
3116: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id
3117: ,ship_to_site_use_id,bill_to_site_use_id,exchange_rate_type --Added for bug 7030415
3118: FROM ozf_funds_utilized_all_b
3119: WHERE price_adjustment_id = p_price_adj_id
3120: AND object_type = p_object_type
3121: AND order_line_id = p_order_line_id;
3122:

Line 3126: FROM ozf_funds_utilized_all_b

3122:
3123: CURSOR c_tp_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2) IS
3124: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id
3125: ,ship_to_site_use_id,bill_to_site_use_id,exchange_rate_type --Added for bug 7030415
3126: FROM ozf_funds_utilized_all_b
3127: WHERE price_adjustment_id = p_price_adj_id
3128: AND object_type = p_object_type;
3129:
3130: -- Added for bug 7030415, cursor for currency conversion type.

Line 3701: FROM ozf_funds_utilized_all_b

3697: ,object_type
3698: ,object_id
3699: ,'Y' gl_posted_flag
3700: ,min(utilization_id) utilization_id
3701: FROM ozf_funds_utilized_all_b
3702: WHERE plan_id = p_list_header_id
3703: AND plan_type = 'OFFR'
3704: -- AND gl_date is not NULL -- only process shipped or invoiced order.
3705: AND gl_posted_flag IN('Y','F')

Line 3718: FROM ozf_funds_utilized_all_b

3714: ,object_type
3715: ,object_id
3716: ,'X' gl_posted_flag
3717: ,min(utilization_id) utilization_id
3718: FROM ozf_funds_utilized_all_b
3719: WHERE plan_id = p_list_header_id
3720: AND plan_type = 'OFFR'
3721: AND gl_posted_flag = 'X'
3722: AND utilization_type IN ('SALES_ACCRUAL','ADJUSTMENT','ACCRUAL')

Line 3734: FROM ozf_funds_utilized_all_b

3730: ,object_type
3731: ,object_id
3732: ,NULL gl_posted_flag
3733: ,min(utilization_id) utilization_id
3734: FROM ozf_funds_utilized_all_b
3735: WHERE plan_id = p_list_header_id
3736: AND plan_type = 'OFFR'
3737: AND gl_posted_flag IS NULL
3738: AND utilization_type IN ('UTILIZED','ADJUSTMENT')

Line 3968: FROM ozf_funds_utilized_all_b

3964: --Added for bug 7030415
3965: l_utilizationIdTbl utilizationIdTbl;
3966: CURSOR c_utilization_details(l_utilization_id IN NUMBER) IS
3967: SELECT exchange_rate_type, org_id
3968: FROM ozf_funds_utilized_all_b
3969: WHERE utilization_id=l_utilization_id;
3970:
3971: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
3972: l_org_id NUMBER;

Line 3971: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

3967: SELECT exchange_rate_type, org_id
3968: FROM ozf_funds_utilized_all_b
3969: WHERE utilization_id=l_utilization_id;
3970:
3971: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
3972: l_org_id NUMBER;
3973:
3974:
3975:

Line 4562: FROM ozf_funds_utilized_all_b

4558: ,object_type
4559: ,object_id
4560: ,min(gl_date) gl_date
4561: ,min(utilization_id) utilization_id
4562: FROM ozf_funds_utilized_all_b
4563: WHERE plan_id = p_list_header_id
4564: AND plan_type = 'OFFR'
4565: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4566: AND price_adjustment_id IS NOT NULL

Line 4586: (SELECT order_line_id FROM ozf_funds_utilized_all_b

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'
4589: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4590: AND price_adjustment_id IS NOT NULL

Line 4595: (SELECT reference_id FROM ozf_funds_utilized_all_b

4591: )
4592: UNION
4593: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL
4594: where resale_batch_id IN
4595: (SELECT reference_id FROM ozf_funds_utilized_all_b
4596: WHERE plan_id = p_list_header_id
4597: AND plan_type = 'OFFR'
4598: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4599: AND price_adjustment_id IS NOT NULL

Line 4610: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

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')
4614: AND price_adjustment_id IS NOT NULL

Line 4619: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

4615: ) orders
4616: where oe.line_id = orders.order_line_id
4617: UNION
4618: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4619: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4620: WHERE plan_id = p_list_header_id
4621: AND plan_type = 'OFFR'
4622: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4623: AND price_adjustment_id IS NOT NULL

Line 4756: FROM ozf_funds_utilized_all_b

4752:
4753:
4754: CURSOR c_volume_detail (p_order_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
4755: SELECT billto_cust_account_id, bill_to_site_use_id, ship_to_site_use_id
4756: FROM ozf_funds_utilized_all_b
4757: WHERE (p_source_code = 'OM' AND object_type = 'ORDER' AND order_line_id = p_order_line_id)
4758: OR (p_source_code = 'IS' AND object_type = 'TP_ORDER' AND object_id = p_order_line_id);
4759:
4760: CURSOR c_all_cust_orders (p_list_header_id IN NUMBER, p_cust_account_id IN NUMBER) IS

Line 4766: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

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')
4770: AND price_adjustment_id IS NOT NULL

Line 4776: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

4772: ) orders
4773: where oe.line_id = orders.order_line_id
4774: UNION
4775: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4776: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4777: WHERE plan_id = p_list_header_id
4778: AND plan_type = 'OFFR'
4779: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4780: AND price_adjustment_id IS NOT NULL

Line 4794: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

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')
4798: AND price_adjustment_id IS NOT NULL

Line 4805: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

4801: ) orders
4802: where oe.line_id = orders.order_line_id
4803: UNION
4804: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4805: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4806: WHERE plan_id = p_list_header_id
4807: AND plan_type = 'OFFR'
4808: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4809: AND price_adjustment_id IS NOT NULL

Line 4827: FROM ozf_funds_utilized_all_b

4823: ,min(price_adjustment_id) price_adjustment_id
4824: ,object_type
4825: ,object_id
4826: ,min(gl_date) gl_date
4827: FROM ozf_funds_utilized_all_b
4828: WHERE plan_id = p_list_header_id
4829: AND plan_type = 'OFFR'
4830: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4831: AND price_adjustment_id IS NOT NULL

Line 4841: FROM ozf_funds_utilized_all_b

4837: ,min(price_adjustment_id) price_adjustment_id
4838: ,object_type
4839: ,object_id
4840: ,min(gl_date) gl_date
4841: FROM ozf_funds_utilized_all_b
4842: WHERE plan_id = p_list_header_id
4843: AND plan_type = 'OFFR'
4844: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4845: AND price_adjustment_id IS NOT NULL

Line 4900: FROM ozf_funds_utilized_all_b

4896: --Added for bug 7030415
4897: l_utilizationIdTbl utilizationIdTbl;
4898: CURSOR c_utilization_details(l_utilization_id IN NUMBER) IS
4899: SELECT exchange_rate_type, org_id
4900: FROM ozf_funds_utilized_all_b
4901: WHERE utilization_id=l_utilization_id;
4902:
4903: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
4904: l_org_id NUMBER;

Line 4903: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

4899: SELECT exchange_rate_type, org_id
4900: FROM ozf_funds_utilized_all_b
4901: WHERE utilization_id=l_utilization_id;
4902:
4903: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
4904: l_org_id NUMBER;
4905:
4906:
4907: