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_SPECIAL_PRICING_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 211: , ozf_request_headers_all_b r

207: CURSOR csr_batch_request(cv_batch_id IN NUMBER, cv_partner_id IN NUMBER) IS
208: SELECT count(1)
209:
210: FROM ozf_resale_lines_int s
211: , ozf_request_headers_all_b r
212: WHERE s.resale_batch_id = cv_batch_id
213: AND s.agreement_name = r.agreement_number
214: AND r.partner_id = cv_partner_id
215: AND r.status_code = 'APPROVED'

Line 1146: ozf_request_headers_all_b r

1142: CURSOR remaining_amount_csr( p_request_header_id NUMBER) is
1143: SELECT r.request_header_id,
1144: sum(fu.acctd_amount_remaining) amount_remaining
1145: FROM ozf_funds_utilized_all_b fu,
1146: ozf_request_headers_all_b r
1147: WHERE r.offer_id = fu.plan_id
1148: AND request_header_id = p_request_header_id
1149: GROUP BY r.request_header_id;
1150: