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 88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;

84: -- Also, we would want to see the performance on customer's instance and then decide on the
85: -- use of profile OZF: Bulk Limit Size
86: g_bulk_limit CONSTANT NUMBER := 10000;
87:
88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;

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

85: -- use of profile OZF: Bulk Limit Size
86: g_bulk_limit CONSTANT NUMBER := 10000;
87:
88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;

Line 90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;

86: g_bulk_limit CONSTANT NUMBER := 10000;
87:
88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;

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

87:
88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;

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

88: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
96: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415

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

89: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
96: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
97:

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

90: TYPE exchangeRateDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
96: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
97:
98: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER

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

91: TYPE objectTypeTbl IS TABLE OF ozf_funds_utilized_all_b.object_type%TYPE;
92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
96: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
97:
98: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER
99: ,order_line_id NUMBER

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

92: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE;
93: TYPE priceAdjustmentIDTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE;
94: TYPE glPostedFlagTbl IS TABLE OF ozf_funds_utilized_all_b.gl_posted_flag%TYPE;
95: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
96: TYPE utilizationIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE; --Added for bug 7030415
97:
98: TYPE order_line_rec_type IS RECORD(order_header_id NUMBER
99: ,order_line_id NUMBER
100: ,inventory_item_id NUMBER

Line 613: FROM ozf_funds_utilized_all_b

609: --nirprasa, 12.1.1 enhancement, replace amount with plan_curr_amount column.
610: --This is a bug since the original accrual is in offer currency.
611: CURSOR c_order_adjustment_amt (p_object_id IN NUMBER, p_order_line_id IN NUMBER, p_prod_id IN NUMBER) IS
612: SELECT SUM(plan_curr_amount)
613: FROM ozf_funds_utilized_all_b
614: WHERE plan_type = 'OFFR'
615: AND plan_id = p_list_header_id
616: AND object_type = 'ORDER'
617: AND object_id = p_object_id

Line 628: FROM ozf_funds_utilized_all_b

624: --nirprasa, 12.1.1 enhancement, replace amount with plan_curr_amount column.
625:
626: CURSOR c_orig_order_adj_amt (p_order_line_id IN NUMBER) IS
627: SELECT SUM(plan_curr_amount)
628: FROM ozf_funds_utilized_all_b
629: WHERE plan_type = 'OFFR'
630: AND plan_id = p_list_header_id
631: AND order_line_id = p_order_line_id
632: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');

Line 1090: FROM ozf_funds_utilized_all_b

1086: AND source_code = 'OM');
1087:
1088: CURSOR c_adjustment_exists (p_list_header_id IN NUMBER, p_order_line_id IN NUMBER) IS
1089: SELECT 1
1090: FROM ozf_funds_utilized_all_b
1091: WHERE plan_id = p_list_header_id
1092: AND plan_type = 'OFFR'
1093: AND order_line_id = p_order_line_id;
1094:

Line 1173: FROM ozf_funds_utilized_all_b

1169:
1170: --nirprasa,12.2 replace amount by plan_curr_amount
1171: CURSOR c_order_adjustment_amt (p_object_id IN NUMBER, p_order_line_id IN NUMBER, p_prod_id IN NUMBER) IS
1172: SELECT SUM(plan_curr_amount)
1173: FROM ozf_funds_utilized_all_b
1174: WHERE plan_type = 'OFFR'
1175: AND plan_id = p_list_header_id
1176: AND object_type = 'ORDER'
1177: AND object_id = p_object_id

Line 1187: FROM ozf_funds_utilized_all_b

1183:
1184:
1185: CURSOR c_order_adj_amount ( p_prod_id IN NUMBER) IS
1186: SELECT SUM(amount)
1187: FROM ozf_funds_utilized_all_b
1188: WHERE plan_type = 'OFFR'
1189: AND plan_id = p_list_header_id
1190: AND object_type = 'ORDER'
1191: -- AND object_id = p_object_id

Line 1293: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

1289: l_current_min_tier NUMBER;
1290: l_current_tier_value NUMBER;
1291: l_previous_tier_max NUMBER;
1292: l_preset_tier NUMBER;
1293: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
1294: l_conv_price NUMBER;
1295: l_rate NUMBER;
1296:
1297: BEGIN

Line 3925: FROM ozf_funds_utilized_all_b

3921: status_code = 'CLOSED'
3922: WHERE offer_adjustment_id = l_adjidbylisthdrid(t_i)
3923: AND EXISTS
3924: (SELECT 1
3925: FROM ozf_funds_utilized_all_b
3926: WHERE request_id = l_request_id
3927: AND plan_id = b.list_header_id
3928: UNION ALL
3929: SELECT 1

Line 3930: FROM ozf_funds_utilized_all_b ofuab,

3926: WHERE request_id = l_request_id
3927: AND plan_id = b.list_header_id
3928: UNION ALL
3929: SELECT 1
3930: FROM ozf_funds_utilized_all_b ofuab,
3931: ozf_resale_adjustments ora
3932: WHERE ofuab.plan_id = b.list_header_id
3933: AND ora.list_header_id = b.list_header_id
3934: AND ofuab.utilization_type = 'ACCRUAL'

Line 4188: FROM ozf_funds_utilized_all_b

4184: CURSOR c_order_adjustment_amt(p_object_id IN NUMBER,
4185: p_order_line_id IN NUMBER, p_prod_id IN NUMBER,
4186: p_list_header_id IN NUMBER) IS
4187: SELECT SUM(plan_curr_amount)
4188: FROM ozf_funds_utilized_all_b
4189: WHERE plan_type = 'OFFR'
4190: AND plan_id = p_list_header_id
4191: AND object_type = 'ORDER'
4192: AND object_id = p_object_id

Line 4230: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

4226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4227: l_adj_amount NUMBER;
4228: l_utilization_amount NUMBER;
4229: l_act_budget_id NUMBER;
4230: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
4231: -- Catch Weight ER
4232: l_cw_quantity NUMBER;
4233: l_cw_quantity_uom VARCHAR2(30);
4234: l_fulfillment_base VARCHAR2(1);

Line 4826: FROM ozf_funds_utilized_all_b

4822:
4823: CURSOR c_orig_order_adj_amt(p_order_line_id IN NUMBER,
4824: p_list_header_id IN NUMBER) IS
4825: SELECT SUM(plan_curr_amount)
4826: FROM ozf_funds_utilized_all_b
4827: WHERE plan_type = 'OFFR'
4828: AND plan_id = p_list_header_id
4829: AND order_line_id = p_order_line_id;
4830:

Line 4844: FROM ozf_funds_utilized_all_b

4840: p_prod_id IN NUMBER,
4841: p_list_header_id IN NUMBER,
4842: p_list_line_id IN NUMBER) IS
4843: SELECT SUM(plan_curr_amount)
4844: FROM ozf_funds_utilized_all_b
4845: WHERE plan_type = 'OFFR'
4846: AND plan_id = p_list_header_id
4847: AND list_line_id IN (SELECT from_list_line_id
4848: FROM ozf_offer_adj_rltd_lines

Line 5345: FROM ozf_funds_utilized_all_b

5341:
5342: CURSOR c_orig_order_adj_amt(p_order_line_id IN NUMBER,
5343: p_list_header_id IN NUMBER) IS
5344: SELECT SUM(plan_curr_amount)
5345: FROM ozf_funds_utilized_all_b
5346: WHERE plan_type = 'OFFR'
5347: AND plan_id = p_list_header_id
5348: AND order_line_id = p_order_line_id;
5349:

Line 5363: FROM ozf_funds_utilized_all_b

5359: p_prod_id IN NUMBER,
5360: p_list_header_id IN NUMBER,
5361: p_list_line_id IN NUMBER) IS
5362: SELECT SUM(plan_curr_amount)
5363: FROM ozf_funds_utilized_all_b
5364: WHERE plan_type = 'OFFR'
5365: AND plan_id = p_list_header_id
5366: AND list_line_id IN (SELECT from_list_line_id
5367: FROM ozf_offer_adj_rltd_lines

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

5993: l_to_date DATE := p_to_date + 0.99999;
5994: l_org_id NUMBER; -- := TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)) ;
5995:
5996: --kpatro 31-JUL-2006 bug 5375224 SQL ID# 19125146 - removed trunc from adjustment_date
5997: --for all cursors and added it to index OZF_FUNDS_UTILIZED_ALL_B_N24 to decrease the cost
5998: --and shared memory of the queries
5999: --nirprasa, 12.2 enhancement, replace amount with plan_curr_amount column.
6000: CURSOR c_bdadj_all_types IS
6001: SELECT util.utilization_id,

Line 6028: FROM ozf_funds_utilized_all_b util,

6024: ,util.bill_to_site_use_id
6025: ,util.reference_type
6026: ,util.reference_id
6027: ,util.exchange_rate_type
6028: FROM ozf_funds_utilized_all_b util,
6029: ozf_temp_eligibility temp,
6030: ozf_offer_adjustment_lines adjl,
6031: oe_order_lines_all ol,
6032: oe_price_adjustments oe

Line 6085: FROM ozf_funds_utilized_all_b util,

6081: ,util.bill_to_site_use_id
6082: ,util.reference_type
6083: ,util.reference_id
6084: ,util.exchange_rate_type
6085: FROM ozf_funds_utilized_all_b util,
6086: ozf_temp_eligibility temp,
6087: ozf_offer_adjustment_lines adjl,
6088: OZF_RESALE_ADJUSTMENTS_ALL oe
6089: WHERE util.plan_type = 'OFFR'

Line 6124: FROM ozf_funds_utilized_all_b util,

6120: DECODE (oe.arithmetic_operator,
6121: 'NEWPRICE', ((oe.operand - adjl.modified_discount) * amount /-oe.adjusted_amount_per_pqty),
6122: ((adjl.modified_discount - oe.operand) * amount / oe.operand)
6123: ) amount
6124: FROM ozf_funds_utilized_all_b util,
6125: oe_price_adj_assocs assocs,
6126: oe_price_adjustments oe,
6127: ozf_offer_adjustment_lines adjl,
6128: ozf_temp_eligibility temp

Line 6170: FROM ozf_funds_utilized_all_b util,

6166: ,util.bill_to_site_use_id
6167: ,util.reference_type
6168: ,util.reference_id
6169: ,util.exchange_rate_type
6170: FROM ozf_funds_utilized_all_b util,
6171: ozf_temp_eligibility temp,
6172: ozf_offer_adjustment_lines adjl,
6173: oe_order_lines_all ol,
6174: oe_price_adjustments oe

Line 6224: FROM ozf_funds_utilized_all_b util,

6220: ,util.bill_to_site_use_id
6221: ,util.reference_type
6222: ,util.reference_id
6223: ,util.exchange_rate_type
6224: FROM ozf_funds_utilized_all_b util,
6225: ozf_temp_eligibility temp,
6226: ozf_offer_adjustment_lines adjl,
6227: OZF_RESALE_ADJUSTMENTS_ALL oe
6228: WHERE util.plan_type = 'OFFR'

Line 6274: FROM ozf_funds_utilized_all_b util,

6270: ,util.bill_to_site_use_id
6271: ,util.reference_type
6272: ,util.reference_id
6273: ,util.exchange_rate_type
6274: FROM ozf_funds_utilized_all_b util,
6275: ozf_temp_eligibility temp,
6276: ozf_offer_adjustment_lines adjl,
6277: oe_order_lines_all ol,
6278: oe_price_adjustments oe

Line 6329: FROM ozf_funds_utilized_all_b util,

6325: ,util.bill_to_site_use_id
6326: ,util.reference_type
6327: ,util.reference_id
6328: ,util.exchange_rate_type
6329: FROM ozf_funds_utilized_all_b util,
6330: ozf_temp_eligibility temp,
6331: ozf_offer_adjustment_lines adjl,
6332: OZF_RESALE_ADJUSTMENTS_ALL oe
6333: WHERE util.plan_type = 'OFFR'

Line 6372: FROM ozf_funds_utilized_all_b util,

6368: ,util.bill_to_site_use_id
6369: ,util.reference_type
6370: ,util.reference_id
6371: ,util.exchange_rate_type
6372: FROM ozf_funds_utilized_all_b util,
6373: ozf_offer_adjustment_lines adjl,
6374: oe_order_lines_all ol,
6375: oe_price_adjustments oe
6376: WHERE util.plan_type = 'OFFR'

Line 6421: FROM ozf_funds_utilized_all_b util,

6417: ,util.bill_to_site_use_id
6418: ,util.reference_type
6419: ,util.reference_id
6420: ,util.exchange_rate_type
6421: FROM ozf_funds_utilized_all_b util,
6422: ozf_temp_eligibility temp,
6423: ozf_offer_adjustment_lines adjl,
6424: oe_order_lines_all ol,
6425: oe_price_adjustments oe

Line 6485: FROM ozf_funds_utilized_all_b

6481: -- added by feliu to fix bug 4451500 and 4015372.
6482: --nirprasa, 12.1.1 enhancement, replace amount with plan_curr_amount
6483: CURSOR c_adj_amount(p_utilization_id IN NUMBER) IS
6484: SELECT sum(plan_curr_amount) adj_amt
6485: FROM ozf_funds_utilized_all_b
6486: --12/16/2005 changed by Feng
6487: WHERE orig_utilization_id = p_utilization_id
6488: --WHERE price_adjustment_id = p_price_adj_id
6489: --AND fund_id = p_fund_id

Line 6497: FROM ozf_funds_utilized_all_b

6493:
6494: --Added for bugfix 6278466
6495: CURSOR c_org_id (p_utilization_id IN NUMBER) IS
6496: SELECT org_id
6497: FROM ozf_funds_utilized_all_b
6498: WHERE utilization_id = p_utilization_id;
6499:
6500: -- get conversion type (nirprasa 12.1.1 fix)
6501: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS

Line 7146: FROM ozf_funds_utilized_all_b

7142: */
7143: CURSOR c_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2,p_order_line_id IN NUMBER) IS
7144: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id
7145: ,ship_to_site_use_id,bill_to_site_use_id,exchange_rate_type --Added for bug 7030415
7146: FROM ozf_funds_utilized_all_b
7147: WHERE price_adjustment_id = p_price_adj_id
7148: AND object_type = p_object_type
7149: AND order_line_id = p_order_line_id;
7150:

Line 7154: FROM ozf_funds_utilized_all_b

7150:
7151: CURSOR c_tp_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2) IS
7152: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id
7153: ,ship_to_site_use_id,bill_to_site_use_id,exchange_rate_type --Added for bug 7030415
7154: FROM ozf_funds_utilized_all_b
7155: WHERE price_adjustment_id = p_price_adj_id
7156: AND object_type = p_object_type;
7157:
7158: -- Added for bug 7030415, cursor for currency conversion type.

Line 7745: FROM ozf_funds_utilized_all_b

7741: ,object_type
7742: ,object_id
7743: ,'Y' gl_posted_flag
7744: ,min(utilization_id) utilization_id
7745: FROM ozf_funds_utilized_all_b
7746: WHERE plan_id = p_list_header_id
7747: AND plan_type = 'OFFR'
7748: -- AND gl_date is not NULL -- only process shipped or invoiced order.
7749: AND gl_posted_flag IN('Y','F')

Line 7763: FROM ozf_funds_utilized_all_b

7759: ,object_type
7760: ,object_id
7761: ,'X' gl_posted_flag
7762: ,min(utilization_id) utilization_id
7763: FROM ozf_funds_utilized_all_b
7764: WHERE plan_id = p_list_header_id
7765: AND plan_type = 'OFFR'
7766: AND gl_posted_flag = 'X'
7767: AND utilization_type IN ('SALES_ACCRUAL','ADJUSTMENT','ACCRUAL')

Line 7780: FROM ozf_funds_utilized_all_b

7776: ,object_type
7777: ,object_id
7778: ,NULL gl_posted_flag
7779: ,min(utilization_id) utilization_id
7780: FROM ozf_funds_utilized_all_b
7781: WHERE plan_id = p_list_header_id
7782: AND plan_type = 'OFFR'
7783: AND gl_posted_flag IS NULL
7784: AND utilization_type IN ('UTILIZED','ADJUSTMENT')

Line 8030: FROM ozf_funds_utilized_all_b

8026: --Added for bug 7030415
8027: l_utilizationIdTbl utilizationIdTbl;
8028: CURSOR c_utilization_details(l_utilization_id IN NUMBER) IS
8029: SELECT exchange_rate_type, org_id
8030: FROM ozf_funds_utilized_all_b
8031: WHERE utilization_id=l_utilization_id;
8032:
8033: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
8034: l_org_id NUMBER;

Line 8033: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

8029: SELECT exchange_rate_type, org_id
8030: FROM ozf_funds_utilized_all_b
8031: WHERE utilization_id=l_utilization_id;
8032:
8033: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
8034: l_org_id NUMBER;
8035:
8036: -- Catch Weight - start
8037: CURSOR c_offer_uom_code(l_offer_id NUMBER) IS

Line 8852: FROM ozf_funds_utilized_all_b

8848: ,object_type
8849: ,object_id
8850: ,min(gl_date) gl_date
8851: ,min(utilization_id) utilization_id
8852: FROM ozf_funds_utilized_all_b
8853: WHERE plan_id = p_list_header_id
8854: AND plan_type = 'OFFR'
8855: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8856: AND price_adjustment_id IS NOT NULL

Line 8876: (SELECT order_line_id FROM ozf_funds_utilized_all_b

8872: select sum(ordered_quantity)
8873: FROM (
8874: select sum(ordered_quantity) ordered_quantity from oe_order_lines_all
8875: where line_id IN
8876: (SELECT order_line_id FROM ozf_funds_utilized_all_b
8877: WHERE plan_id = p_list_header_id
8878: AND plan_type = 'OFFR'
8879: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8880: AND price_adjustment_id IS NOT NULL

Line 8885: (SELECT reference_id FROM ozf_funds_utilized_all_b

8881: )
8882: UNION
8883: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL
8884: where resale_batch_id IN
8885: (SELECT reference_id FROM ozf_funds_utilized_all_b
8886: WHERE plan_id = p_list_header_id
8887: AND plan_type = 'OFFR'
8888: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8889: AND price_adjustment_id IS NOT NULL

Line 8900: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

8896: FROM (
8897: SELECT SUM(DECODE(line_category_code,'ORDER',ordered_quantity,
8898: 'RETURN', -ordered_quantity)) ordered_quantity
8899: from oe_order_lines_all oe,
8900: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
8901: WHERE plan_id = p_list_header_id
8902: AND plan_type = 'OFFR'
8903: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8904: AND price_adjustment_id IS NOT NULL

Line 8909: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

8905: ) orders
8906: where oe.line_id = orders.order_line_id
8907: UNION
8908: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
8909: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
8910: WHERE plan_id = p_list_header_id
8911: AND plan_type = 'OFFR'
8912: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8913: AND price_adjustment_id IS NOT NULL

Line 9046: FROM ozf_funds_utilized_all_b

9042:
9043:
9044: CURSOR c_volume_detail (p_order_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
9045: SELECT billto_cust_account_id, bill_to_site_use_id, ship_to_site_use_id
9046: FROM ozf_funds_utilized_all_b
9047: WHERE (p_source_code = 'OM' AND object_type = 'ORDER' AND order_line_id = p_order_line_id)
9048: OR (p_source_code = 'IS' AND object_type = 'TP_ORDER' AND object_id = p_order_line_id);
9049:
9050: CURSOR c_all_cust_orders (p_list_header_id IN NUMBER, p_cust_account_id IN NUMBER) IS

Line 9056: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

9052: FROM (
9053: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
9054: 'RETURN', -ordered_quantity)) ordered_quantity
9055: from oe_order_lines_all oe,
9056: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
9057: WHERE plan_id = p_list_header_id
9058: AND plan_type = 'OFFR'
9059: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9060: AND price_adjustment_id IS NOT NULL

Line 9066: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

9062: ) orders
9063: where oe.line_id = orders.order_line_id
9064: UNION
9065: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
9066: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
9067: WHERE plan_id = p_list_header_id
9068: AND plan_type = 'OFFR'
9069: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9070: AND price_adjustment_id IS NOT NULL

Line 9084: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b

9080: FROM (
9081: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
9082: 'RETURN', -ordered_quantity)) ordered_quantity
9083: from oe_order_lines_all oe,
9084: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
9085: WHERE plan_id = p_list_header_id
9086: AND plan_type = 'OFFR'
9087: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9088: AND price_adjustment_id IS NOT NULL

Line 9095: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b

9091: ) orders
9092: where oe.line_id = orders.order_line_id
9093: UNION
9094: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
9095: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
9096: WHERE plan_id = p_list_header_id
9097: AND plan_type = 'OFFR'
9098: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9099: AND price_adjustment_id IS NOT NULL

Line 9117: FROM ozf_funds_utilized_all_b

9113: ,min(price_adjustment_id) price_adjustment_id
9114: ,object_type
9115: ,object_id
9116: ,min(gl_date) gl_date
9117: FROM ozf_funds_utilized_all_b
9118: WHERE plan_id = p_list_header_id
9119: AND plan_type = 'OFFR'
9120: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9121: AND price_adjustment_id IS NOT NULL

Line 9131: FROM ozf_funds_utilized_all_b

9127: ,min(price_adjustment_id) price_adjustment_id
9128: ,object_type
9129: ,object_id
9130: ,min(gl_date) gl_date
9131: FROM ozf_funds_utilized_all_b
9132: WHERE plan_id = p_list_header_id
9133: AND plan_type = 'OFFR'
9134: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
9135: AND price_adjustment_id IS NOT NULL

Line 9190: FROM ozf_funds_utilized_all_b

9186: --Added for bug 7030415
9187: l_utilizationIdTbl utilizationIdTbl;
9188: CURSOR c_utilization_details(l_utilization_id IN NUMBER) IS
9189: SELECT exchange_rate_type, org_id
9190: FROM ozf_funds_utilized_all_b
9191: WHERE utilization_id=l_utilization_id;
9192:
9193: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
9194: l_org_id NUMBER;

Line 9193: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

9189: SELECT exchange_rate_type, org_id
9190: FROM ozf_funds_utilized_all_b
9191: WHERE utilization_id=l_utilization_id;
9192:
9193: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
9194: l_org_id NUMBER;
9195:
9196:
9197: