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.

VIEW: APPS.CLN_ITEMMST_CUSTOMER_V

Source

View Text - Preformatted


SELECT hp.party_name PARTY_NAME, eth.party_id PARTY_ID, etd.external_tp_location_code CUSTOMER_PARTNRIDX from ecx_tp_headers eth, ecx_tp_details etd, ecx_ext_processes eep, ecx_transactions et, hz_parties hp WHERE eth.tp_header_id = etd.tp_header_id and eth.party_id = hp.party_id and etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID and eep.transaction_id = et.transaction_id and et.transaction_type = 'CLN' and et.transaction_subtype = 'SYNCITEMO' and eep.direction = 'OUT'

View Text - HTML Formatted

SELECT HP.PARTY_NAME PARTY_NAME
, ETH.PARTY_ID PARTY_ID
, ETD.EXTERNAL_TP_LOCATION_CODE CUSTOMER_PARTNRIDX
FROM ECX_TP_HEADERS ETH
, ECX_TP_DETAILS ETD
, ECX_EXT_PROCESSES EEP
, ECX_TRANSACTIONS ET
, HZ_PARTIES HP
WHERE ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETH.PARTY_ID = HP.PARTY_ID
AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID
AND EEP.TRANSACTION_ID = ET.TRANSACTION_ID
AND ET.TRANSACTION_TYPE = 'CLN'
AND ET.TRANSACTION_SUBTYPE = 'SYNCITEMO'
AND EEP.DIRECTION = 'OUT'