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 8883: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL

8879: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')
8880: AND price_adjustment_id IS NOT NULL
8881: )
8882: UNION
8883: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL
8884: where resale_batch_id IN
8885: (SELECT reference_id FROM ozf_funds_utilized_all_b
8886: WHERE plan_id = p_list_header_id
8887: AND plan_type = 'OFFR'

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

8904: AND price_adjustment_id IS NOT NULL
8905: ) orders
8906: where oe.line_id = orders.order_line_id
8907: UNION
8908: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
8909: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
8910: WHERE plan_id = p_list_header_id
8911: AND plan_type = 'OFFR'
8912: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

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

9061: AND cust_account_id = p_cust_account_id
9062: ) orders
9063: where oe.line_id = orders.order_line_id
9064: UNION
9065: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
9066: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
9067: WHERE plan_id = p_list_header_id
9068: AND plan_type = 'OFFR'
9069: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

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

9090: AND gl_date <= p_transaction_date
9091: ) orders
9092: where oe.line_id = orders.order_line_id
9093: UNION
9094: select sum(quantity) ordered_quantity from OZF_RESALE_LINES_INT_ALL ol ,
9095: (SELECT distinct reference_id FROM ozf_funds_utilized_all_b
9096: WHERE plan_id = p_list_header_id
9097: AND plan_type = 'OFFR'
9098: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')