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.CLN_CH_COLLABORATION_PKG dependencies on ECX_STANDARDS

Line 3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd

3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code
3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard
3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
3840: WHERE eth.party_id = p_tr_partner_id
3841: AND eth.party_site_id = p_tr_partner_site
3842: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
3843: AND eth.tp_header_id = etd.tp_header_id

Line 3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id
3942: AND estd.standard_code = l_xmlg_msg_standard

Line 3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3973:
3974: BEGIN
3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id
3981: AND estd.standard_code = l_xmlg_msg_standard

Line 4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

4661: END IF;
4662:
4663: SELECT doclogs.internal_control_number
4664: INTO l_corrspnd_internal_cntrl_num
4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
4666: WHERE doclogs.direction = 'IN' and doclogs.field7 = l_data_area_refid
4667: AND eep.ext_type = doclogs.transaction_type
4668: AND eep.ext_subtype = doclogs.transaction_subtype
4669: AND eep.standard_id = estd.standard_id