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.ZX_API_PRVDR_PUB dependencies on ZX_SERVICE_TYPES

Line 79: from zx_service_types

75: p_error_counter := p_error_counter+1;
76: Else
77: select service_type_id
78: into x_srvc_type_id
79: from zx_service_types
80: where SERVICE_TYPE_CODE = p_srvc_type_code
81: and SERVICE_CATEGORY_CODE = G_SRVC_CATEGORY;
82: END IF;
83:

Line 213: zx_service_types srvc

209: BEGIN
210: SELECT 1
211: INTO l_exists
212: FROM zx_api_registrations reg,
213: zx_service_types srvc
214: WHERE reg.api_owner_id = l_api_owner_id
215: AND srvc.service_type_id = reg.service_type_id
216: AND srvc.service_type_code = p_srvc_type_code
217: AND context_ccid = l_code_combination_id;

Line 233: FROM ZX_SERVICE_TYPES

229: END;
230: ELSE /*create the combination*/
231: SELECT context_flex_structure_id
232: INTO l_context_flex_structure
233: FROM ZX_SERVICE_TYPES
234: WHERE service_type_code = p_srvc_type_code
235: AND service_category_code = G_SRVC_CATEGORY;
236:
237: -- need to create ccid for the new tax_regime_code

Line 413: zx_service_types srvc

409: DELETE from ZX_API_REGISTRATIONS
410: WHERE EXISTS (SELECT *
411: FROM zx_api_registrations reg,
412: zx_api_code_combinations cmbn,
413: zx_service_types srvc
414: WHERE reg.api_owner_id = l_api_owner_id
415: AND srvc.service_type_id = reg.service_type_id
416: AND srvc.service_type_code = p_srvc_type_code
417: AND cmbn.segment_attribute1 = p_country_code