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 4014: FROM qp_list_headers_vl

4010:
4011: CURSOR get_pl_agreement_name_csr(pc_agreement_id NUMBER)
4012: IS
4013: SELECT name
4014: FROM qp_list_headers_vl
4015: WHERE list_header_id = pc_agreement_id
4016: AND list_type_code = 'PRL';
4017:
4018: CURSOR get_spo_agreement_name_csr(pc_agreement_id NUMBER)

Line 4109: FROM qp_list_headers_vl

4105:
4106: CURSOR chk_pl_agreement ( pc_agreement_id NUMBER )
4107: IS
4108: SELECT 'X'
4109: FROM qp_list_headers_vl
4110: WHERE list_header_id = pc_agreement_id
4111: AND list_type_code = 'PRL';
4112:
4113: CURSOR chk_spo_agreement ( pc_agreement_id NUMBER )

Line 4124: FROM qp_list_headers_vl

4120: -- [BEGINN OF BUG FIXING: Agreement is null]
4121: CURSOR get_pl_agreement_id(pc_agreement_name VARCHAR2)
4122: IS
4123: SELECT list_header_id
4124: FROM qp_list_headers_vl
4125: WHERE name = pc_agreement_name
4126: AND list_type_code = 'PRL';
4127: --*/
4128: -- [END OF BUG FIXING: Agreement is null]

Line 4134: , qp_list_headers_vl b

4130: -- [BEGIN OF BUG 4237990 FIXING]
4131: CURSOR get_spo_agreement_id(cv_agreement_name VARCHAR) IS
4132: SELECT a.request_header_id
4133: FROM ozf_request_headers_all_b a
4134: , qp_list_headers_vl b
4135: WHERE a.offer_id = b.list_header_id
4136: AND a.status_code = 'APPROVED'
4137: AND b.name = cv_agreement_name;
4138: -- [END OF BUG 4237990 FIXING]