APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_ADJUSTMENTS_ALL

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 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 ||