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 58: FROM ozf_resale_adjustments

54: WHERE qp_list_header_id = p_list_header_id;
55:
56: CURSOR line_adjustment_csr IS
57: SELECT 1
58: FROM ozf_resale_adjustments
59: WHERE resale_line_id = p_line_id
60: AND list_header_id = p_list_header_id
61: AND list_line_id = p_list_line_id;
62:

Line 499: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;

495: m NUMBER := 1;
496:
497: --l_pric_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
498: --l_pric_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
499: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;
500:
501: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
502: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
503: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;

Line 503: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;

499: --l_pric_price_adj_rec ozf_resale_adjustments_all%rowtype;
500:
501: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
502: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
503: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;
504:
505: l_is_valid_offer BOOLEAN;
506: l_price_diff_util BOOLEAN;
507: l_object_type VARCHAR2(30);

Line 532: FROM ozf_resale_adjustments a, ozf_resale_batches b

528: a.corrected_agreement_id,
529: a.corrected_agreement_name,
530: a.credit_code,
531: a.credit_advice_date
532: FROM ozf_resale_adjustments a, ozf_resale_batches b
533: WHERE a.resale_line_id = p_line_id
534: AND a.resale_batch_id = p_batch_id
535: AND a.line_agreement_flag = 'T'
536: AND a.resale_batch_id = b.resale_batch_id