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_RESALE_LINES_INT_ALL

Line 4593: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL

4589: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
4590: AND price_adjustment_id IS NOT NULL
4591: )
4592: UNION
4593: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL
4594: where resale_batch_id IN
4595: (SELECT reference_id FROM ozf_funds_utilized_all_b
4596: WHERE plan_id = p_list_header_id
4597: AND plan_type = 'OFFR'

Line 4618: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,

4614: AND price_adjustment_id IS NOT NULL
4615: ) orders
4616: where oe.line_id = orders.order_line_id
4617: UNION
4618: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4619: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4620: WHERE plan_id = p_list_header_id
4621: AND plan_type = 'OFFR'
4622: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

Line 4775: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,

4771: AND cust_account_id = p_cust_account_id
4772: ) orders
4773: where oe.line_id = orders.order_line_id
4774: UNION
4775: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4776: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4777: WHERE plan_id = p_list_header_id
4778: AND plan_type = 'OFFR'
4779: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

Line 4804: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,

4800: AND gl_date <= p_transaction_date
4801: ) orders
4802: where oe.line_id = orders.order_line_id
4803: UNION
4804: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
4805: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
4806: WHERE plan_id = p_list_header_id
4807: AND plan_type = 'OFFR'
4808: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')