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.POS_SUPP_PUB_RESPONSES_V

Source

View Text - Preformatted


SELECT spr.publication_event_id, spr.target_system, ht.orig_system_name, spr.party_id, spr.request_process_id, spr.request_process_status, spr.response_process_id, spr.response_process_status, spr.target_system_response_date, spr.error_message, spr.created_by, spr.creation_date, spr.last_updated_by, spr.last_update_date, spr.last_update_login FROM pos_supp_pub_responses spr, hz_orig_systems_b hb, hz_orig_systems_tl ht WHERE hb.orig_system = spr.target_system AND hb.orig_system_id = ht.orig_system_id AND ht.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT SPR.PUBLICATION_EVENT_ID
, SPR.TARGET_SYSTEM
, HT.ORIG_SYSTEM_NAME
, SPR.PARTY_ID
, SPR.REQUEST_PROCESS_ID
, SPR.REQUEST_PROCESS_STATUS
, SPR.RESPONSE_PROCESS_ID
, SPR.RESPONSE_PROCESS_STATUS
, SPR.TARGET_SYSTEM_RESPONSE_DATE
, SPR.ERROR_MESSAGE
, SPR.CREATED_BY
, SPR.CREATION_DATE
, SPR.LAST_UPDATED_BY
, SPR.LAST_UPDATE_DATE
, SPR.LAST_UPDATE_LOGIN
FROM POS_SUPP_PUB_RESPONSES SPR
, HZ_ORIG_SYSTEMS_B HB
, HZ_ORIG_SYSTEMS_TL HT
WHERE HB.ORIG_SYSTEM = SPR.TARGET_SYSTEM
AND HB.ORIG_SYSTEM_ID = HT.ORIG_SYSTEM_ID
AND HT.LANGUAGE = USERENV('LANG')