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.PV_GQ_ELEMENTS_PVT dependencies on PV_GE_QSNR_ELEMENTS_VL

Line 976: from pv_ge_qsnr_elements_vl gq,

972: IS
973:
974: CURSOR c_get_elmt_greater_than (cv_qsnr_element_id NUMBER) IS
975: select gq.qsnr_element_id, gq.qsnr_elmt_seq_num, gq.qsnr_elmt_page_num, gq.object_version_number
976: from pv_ge_qsnr_elements_vl gq,
977: (select arc_used_by_entity_code, used_by_entity_id, qsnr_elmt_seq_num
978: from pv_ge_qsnr_elements_vl
979: where qsnr_element_id = cv_qsnr_element_id) tmp
980: where gq.arc_used_by_entity_code = tmp.arc_used_by_entity_code

Line 978: from pv_ge_qsnr_elements_vl

974: CURSOR c_get_elmt_greater_than (cv_qsnr_element_id NUMBER) IS
975: select gq.qsnr_element_id, gq.qsnr_elmt_seq_num, gq.qsnr_elmt_page_num, gq.object_version_number
976: from pv_ge_qsnr_elements_vl gq,
977: (select arc_used_by_entity_code, used_by_entity_id, qsnr_elmt_seq_num
978: from pv_ge_qsnr_elements_vl
979: where qsnr_element_id = cv_qsnr_element_id) tmp
980: where gq.arc_used_by_entity_code = tmp.arc_used_by_entity_code
981: and gq.used_by_entity_id = tmp.used_by_entity_id
982: and gq.qsnr_elmt_seq_num > tmp.qsnr_elmt_seq_num;

Line 1186: from pv_ge_qsnr_elements_vl gq,

1182: IS
1183:
1184: CURSOR c_get_elmt_greater_than (cv_qsnr_element_id NUMBER) IS
1185: select gq.qsnr_element_id, gq.qsnr_elmt_seq_num, gq.qsnr_elmt_page_num, gq.object_version_number
1186: from pv_ge_qsnr_elements_vl gq,
1187: (select arc_used_by_entity_code, used_by_entity_id, qsnr_elmt_seq_num
1188: from pv_ge_qsnr_elements_vl
1189: where qsnr_element_id = cv_qsnr_element_id) tmp
1190: where gq.arc_used_by_entity_code = tmp.arc_used_by_entity_code

Line 1188: from pv_ge_qsnr_elements_vl

1184: CURSOR c_get_elmt_greater_than (cv_qsnr_element_id NUMBER) IS
1185: select gq.qsnr_element_id, gq.qsnr_elmt_seq_num, gq.qsnr_elmt_page_num, gq.object_version_number
1186: from pv_ge_qsnr_elements_vl gq,
1187: (select arc_used_by_entity_code, used_by_entity_id, qsnr_elmt_seq_num
1188: from pv_ge_qsnr_elements_vl
1189: where qsnr_element_id = cv_qsnr_element_id) tmp
1190: where gq.arc_used_by_entity_code = tmp.arc_used_by_entity_code
1191: and gq.used_by_entity_id = tmp.used_by_entity_id
1192: and gq.qsnr_elmt_seq_num > tmp.qsnr_elmt_seq_num;

Line 2211: from pv_ge_qsnr_elements_vl

2207: IS
2208:
2209: CURSOR c_get_used_by_entity (cv_qsnr_element_id NUMBER) IS
2210: select arc_used_by_entity_code, used_by_entity_id, qsnr_elmt_seq_num
2211: from pv_ge_qsnr_elements_vl
2212: where qsnr_element_id = cv_qsnr_element_id;
2213:
2214: CURSOR c_get_qsnr (cv_qsnr_elmt_seq_num NUMBER,
2215: cv_arc_used_by_entity_code VARCHAR2,

Line 2218: FROM PV_GE_QSNR_ELEMENTS_VL

2214: CURSOR c_get_qsnr (cv_qsnr_elmt_seq_num NUMBER,
2215: cv_arc_used_by_entity_code VARCHAR2,
2216: cv_used_by_entity_id NUMBER) IS
2217: SELECT *
2218: FROM PV_GE_QSNR_ELEMENTS_VL
2219: WHERE qsnr_elmt_seq_num = cv_qsnr_elmt_seq_num
2220: AND arc_used_by_entity_code = cv_arc_used_by_entity_code
2221: AND used_by_entity_id = cv_used_by_entity_id;
2222: