DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on ECX_TP_DETAILS

Line 1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

1310:
1311: BEGIN
1312: SELECT to_char(eth.tp_header_id)
1313: INTO p_tr_partner_id
1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
1315: WHERE doclogs.internal_control_number = p_xmlg_internal_control_number
1316: AND eep.ext_type = doclogs.transaction_type
1317: AND eep.ext_subtype = doclogs.transaction_subtype
1318: AND eep.standard_id = estd.standard_id

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

1623:
1624: BEGIN
1625: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE
1626: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype
1627: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
1628: WHERE eth.party_id = l_tr_partner_id
1629: AND eth.party_site_id = l_tr_partner_site
1630: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
1631: AND eth.tp_header_id = etd.tp_header_id