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_CLAIM_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 4920: ozf_resale_lines_int_all orl

4916: SELECT
4917: sum(orl.total_accepted_amount)
4918: FROM
4919: ozf_resale_batches_all orb,
4920: ozf_resale_lines_int_all orl
4921: WHERE
4922: orb.batch_type = 'CHARGEBACK'
4923: AND orb.resale_batch_id = orl.resale_batch_id
4924: AND orl.resale_batch_id = p_resale_batch_id

Line 5531: ozf_resale_lines_int_all orl

5527: orl.inventory_item_id product_id,
5528: orb.currency_code currency_code
5529: FROM
5530: ozf_resale_batches_all orb,
5531: ozf_resale_lines_int_all orl
5532: WHERE
5533: orb.batch_type = 'CHARGEBACK'
5534: AND orb.resale_batch_id = orl.resale_batch_id
5535: AND orb.resale_batch_id = p_resale_batch_id

Line 5546: ozf_resale_lines_int_all orl

5542: SELECT
5543: orl.resale_line_int_id
5544: FROM
5545: ozf_resale_batches_all orb,
5546: ozf_resale_lines_int_all orl
5547: WHERE
5548: orb.batch_type = 'CHARGEBACK'
5549: AND orb.resale_batch_id = orl.resale_batch_id
5550: AND orb.resale_batch_id = p_resale_batch_id

Line 7408: FROM ozf_resale_lines_int_all s,

7404: , s.currency_code
7405: , sum(s.quantity)
7406: , sum(s.total_accepted_amount)
7407:
7408: FROM ozf_resale_lines_int_all s,
7409: ozf_request_headers_all_b r
7410: WHERE s.resale_batch_id = cv_batch_id
7411: AND s.status_code = 'PROCESSED'
7412: AND s.agreement_name = r.agreement_number