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: APPLSYS.FND_SOA_REQUEST#

Source

View Text - Preformatted


select CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MESSAGE_ID MESSAGE_ID, REQUEST_TIMESTAMP REQUEST_TIMESTAMP, USER_ID USER_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE NLS_LANGUAGE, SECURITY_GROUP_NAME SECURITY_GROUP_NAME, IREP_NAME IREP_NAME, IP_ADDRESS IP_ADDRESS, TARGET_URI TARGET_URI, METHOD METHOD, INTERFACE INTERFACE, NO_OF_ATTACHMENTS NO_OF_ATTACHMENTS, ATTRIB1 ATTRIB1, ATTRIB2 ATTRIB2, ATTRIB3 ATTRIB3, ATTRIB4 ATTRIB4, ATTRIB5 ATTRIB5, ATTRIB6 ATTRIB6, ATTRIB7 ATTRIB7, ATTRIB8 ATTRIB8, ATTRIB9 ATTRIB9, ATTRIB10 ATTRIB10, ATTRIB11 ATTRIB11, ATTRIB12 ATTRIB12, ATTRIB13 ATTRIB13, ATTRIB14 ATTRIB14, ATTRIB15 ATTRIB15, REQUEST_STATUS REQUEST_STATUS, RESPONSE_STATUS RESPONSE_STATUS, REQUEST_STARTED REQUEST_STARTED, REQUEST_COMPLETED REQUEST_COMPLETED, REQUEST_RESPONDED REQUEST_RESPONDED, REQUEST_PATTERN REQUEST_PATTERN, EXECUTION_ATTEMPTS EXECUTION_ATTEMPTS, DELIVERY_ATTEMPTS DELIVERY_ATTEMPTS, NO_OF_RESPONSE_ATTACHMENTS NO_OF_RESPONSE_ATTACHMENTS, DIRECTION DIRECTION from "APPLSYS"."FND_SOA_REQUEST"

View Text - HTML Formatted

SELECT CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MESSAGE_ID MESSAGE_ID
, REQUEST_TIMESTAMP REQUEST_TIMESTAMP
, USER_ID USER_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID
, NLS_LANGUAGE NLS_LANGUAGE
, SECURITY_GROUP_NAME SECURITY_GROUP_NAME
, IREP_NAME IREP_NAME
, IP_ADDRESS IP_ADDRESS
, TARGET_URI TARGET_URI
, METHOD METHOD
, INTERFACE INTERFACE
, NO_OF_ATTACHMENTS NO_OF_ATTACHMENTS
, ATTRIB1 ATTRIB1
, ATTRIB2 ATTRIB2
, ATTRIB3 ATTRIB3
, ATTRIB4 ATTRIB4
, ATTRIB5 ATTRIB5
, ATTRIB6 ATTRIB6
, ATTRIB7 ATTRIB7
, ATTRIB8 ATTRIB8
, ATTRIB9 ATTRIB9
, ATTRIB10 ATTRIB10
, ATTRIB11 ATTRIB11
, ATTRIB12 ATTRIB12
, ATTRIB13 ATTRIB13
, ATTRIB14 ATTRIB14
, ATTRIB15 ATTRIB15
, REQUEST_STATUS REQUEST_STATUS
, RESPONSE_STATUS RESPONSE_STATUS
, REQUEST_STARTED REQUEST_STARTED
, REQUEST_COMPLETED REQUEST_COMPLETED
, REQUEST_RESPONDED REQUEST_RESPONDED
, REQUEST_PATTERN REQUEST_PATTERN
, EXECUTION_ATTEMPTS EXECUTION_ATTEMPTS
, DELIVERY_ATTEMPTS DELIVERY_ATTEMPTS
, NO_OF_RESPONSE_ATTACHMENTS NO_OF_RESPONSE_ATTACHMENTS
, DIRECTION DIRECTION
FROM "APPLSYS"."FND_SOA_REQUEST"