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

Line 424: FROM ozf_resale_adjustments

420: l_result VARCHAR2(2) := NULL;
421:
422: CURSOR line_adjustment_csr IS
423: SELECT 1
424: FROM ozf_resale_adjustments
425: WHERE resale_line_id = p_line_id
426: AND list_header_id = p_list_header_id
427: AND list_line_id IN
428: ( (SELECT from_list_line_id

Line 490: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;

486: l_return_status VARCHAR2(1);
487: l_msg_data VARCHAR2(2000);
488: l_msg_count NUMBER;
489:
490: l_adjustment_rec OZF_RESALE_ADJUSTMENTS_ALL%rowtype;
491: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
492: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
493: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.sales_transaction_rec_type;
494: l_resale_util_rec resale_util_rec_type := p_resale_util_rec;

Line 596: FROM ozf_resale_adjustments

592:
593:
594: CURSOR line_adjustment_csr IS
595: SELECT 1
596: FROM ozf_resale_adjustments
597: WHERE resale_line_id = p_resale_util_rec.resale_line_id
598: AND list_header_id = p_resale_util_rec.list_header_id
599: AND list_line_id IN ((SELECT from_list_line_id
600: FROM ozf_offer_adj_rltd_lines