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_TP_ACCRUAL_PVT dependencies on OZF_RESALE_ADJUSTMENTS

Line 65: FROM ozf_resale_adjustments

61: -- Fix for bug 12967249 : added the current list_line_id also to the cursor, so that it will not validate the offer once accrual is created for the same line
62: -- Fix for bug 13461834 : modified the cursor , so that inner query will not fail for more than one adjustments.
63: /*CURSOR line_adjustment_csr IS
64: SELECT 1
65: FROM ozf_resale_adjustments
66: WHERE resale_line_id = p_line_id
67: AND list_header_id = p_list_header_id
68: AND list_line_id IN
69: (SELECT from_list_line_id

Line 78: FROM ozf_resale_adjustments

74: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id);*/
75:
76: CURSOR line_adjustment_csr IS
77: SELECT 1
78: FROM ozf_resale_adjustments
79: WHERE resale_line_id = p_line_id
80: AND list_header_id = p_list_header_id
81: AND((list_line_id = p_list_line_id)
82: OR(list_line_id IN

Line 544: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;

540: m NUMBER := 1;
541:
542: --l_pric_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
543: --l_pric_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
544: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;
545:
546: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
547: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
548: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;

Line 548: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;

544: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;
545:
546: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
547: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
548: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;
549:
550: l_is_valid_offer BOOLEAN;
551: l_price_diff_util BOOLEAN;
552: l_object_type VARCHAR2(30);

Line 578: FROM ozf_resale_adjustments a, ozf_resale_batches b

574: a.corrected_agreement_id,
575: a.corrected_agreement_name,
576: a.credit_code,
577: a.credit_advice_date
578: FROM ozf_resale_adjustments a, ozf_resale_batches b
579: WHERE a.resale_line_id = p_line_id
580: AND a.resale_batch_id = p_batch_id
581: AND a.line_agreement_flag = 'T'
582: AND a.resale_batch_id = b.resale_batch_id

Line 5838: ozf_offers off, ozf_resale_adjustments_all oe,

5834: line.quantity ShippedQuantity,
5835: (line.quantity*NVL(line.selling_price,line.purchase_price)) Revenue,
5836: NVL(util.plan_curr_amount,0) AccrualAmount
5837: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,
5838: ozf_offers off, ozf_resale_adjustments_all oe,
5839: ozf_xref_map map
5840: WHERE line.resale_line_id = util.object_id
5841: AND util.object_type = ''TP_ORDER''
5842: AND util.request_id = ' || G_CONC_REQUEST_ID ||

Line 5862: ozf_offers off, ozf_resale_adjustments_all oe,

5858: line.quantity ShippedQuantity,
5859: (line.quantity*NVL(line.selling_price,line.purchase_price)) Revenue,
5860: NVL(util.plan_curr_amount,0) AccrualAmount
5861: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,
5862: ozf_offers off, ozf_resale_adjustments_all oe,
5863: ozf_xref_map map
5864: WHERE line.resale_line_id = util.object_id
5865: AND util.object_type = ''TP_ORDER''
5866: AND util.request_id = ' || G_CONC_REQUEST_ID ||