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_PRE_PROCESS_PVT dependencies on QP_LIST_HEADERS_VL

Line 4342: FROM qp_list_headers_vl

4338:
4339: CURSOR get_pl_agreement_name_csr(pc_agreement_id NUMBER)
4340: IS
4341: SELECT name
4342: FROM qp_list_headers_vl
4343: WHERE list_header_id = pc_agreement_id
4344: AND list_type_code = 'PRL';
4345:
4346: CURSOR get_spo_agreement_name_csr(pc_agreement_id NUMBER)

Line 4439: FROM qp_list_headers_vl

4435:
4436: CURSOR chk_pl_agreement ( pc_agreement_id NUMBER )
4437: IS
4438: SELECT 'X'
4439: FROM qp_list_headers_vl
4440: WHERE list_header_id = pc_agreement_id
4441: AND list_type_code = 'PRL';
4442:
4443: CURSOR chk_spo_agreement ( pc_agreement_id NUMBER )

Line 4454: FROM qp_list_headers_vl

4450: -- [BEGINN OF BUG FIXING: Agreement is null]
4451: CURSOR get_pl_agreement_id(pc_agreement_name VARCHAR2)
4452: IS
4453: SELECT list_header_id
4454: FROM qp_list_headers_vl
4455: WHERE name = pc_agreement_name
4456: AND list_type_code = 'PRL';
4457: --*/
4458: -- [END OF BUG FIXING: Agreement is null]

Line 4464: , qp_list_headers_vl b

4460: -- [BEGIN OF BUG 4237990 FIXING]
4461: CURSOR get_spo_agreement_id(cv_agreement_name VARCHAR) IS
4462: SELECT a.request_header_id
4463: FROM ozf_request_headers_all_b a
4464: , qp_list_headers_vl b
4465: WHERE a.offer_id = b.list_header_id
4466: AND a.status_code = 'APPROVED'
4467: AND b.name = cv_agreement_name;
4468: -- [END OF BUG 4237990 FIXING]