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_PARTNER_CONTRACTS_PVT dependencies on PV_ENTY_ATTR_VALUES

Line 114: FROM pv_enty_attr_values eav, pv_program_contracts ppc, okc_terms_templates_all term

110: WHERE partner_id = p_partner_id;
111:
112: CURSOR c_get_geo_hierarchy_id (cv_partner_id NUMBER, cv_program_id NUMBER) IS
113: SELECT ppc.geo_hierarchy_id
114: FROM pv_enty_attr_values eav, pv_program_contracts ppc, okc_terms_templates_all term
115: WHERE eav.entity_id = cv_partner_id
116: AND eav.attribute_id = 6
117: AND eav.entity = 'PARTNER'
118: AND eav.latest_flag = 'Y'

Line 128: FROM pv_enty_attr_values eav, pv_program_contracts ppc, okc_terms_templates_all term

124: AND (term.end_date is null or term.end_date > sysdate);
125:
126: CURSOR c_get_contract_id (cv_partner_id NUMBER, cv_program_id NUMBER, cv_geo_hierarchy_id NUMBER) IS
127: SELECT ppc.contract_id
128: FROM pv_enty_attr_values eav, pv_program_contracts ppc, okc_terms_templates_all term
129: WHERE eav.entity_id = cv_partner_id
130: AND eav.attribute_id = 6
131: AND eav.entity = 'PARTNER'
132: AND eav.latest_flag = 'Y'