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.

[Home] [Help]

View: IBY_EXT_FD_PPR_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_EXT_FD_PPR_1_0_V

View Text

SELECT PPR.PAYMENT_SERVICE_REQUEST_ID
, PPR.CALLING_APP_ID
, FND_APP.APPLICATION_NAME
, PPR.CALL_APP_PAY_SERVICE_REQ_CODE
, PPR.CREATION_DATE
, PPR.PAYMENT_SERVICE_REQUEST_STATUS
, PPR_STATUS_LOOKUP.MEANING
, PPR.PROCESS_TYPE
, PPR.ATTRIBUTE_CATEGORY
, PPR_PROCESS_TYPE_LOOKUP.MEANING
FROM FND_LOOKUPS PPR_PROCESS_TYPE_LOOKUP
, FND_APPLICATION_VL FND_APP
, IBY_PAY_SERVICE_REQUESTS PPR
, FND_LOOKUPS PPR_STATUS_LOOKUP
WHERE PPR.CALLING_APP_ID = FND_APP.APPLICATION_ID
AND PPR.PAYMENT_SERVICE_REQUEST_STATUS = PPR_STATUS_LOOKUP.LOOKUP_CODE
AND PPR_STATUS_LOOKUP.LOOKUP_TYPE = 'IBY_REQUEST_STATUSES'
AND PPR.PROCESS_TYPE = PPR_PROCESS_TYPE_LOOKUP.LOOKUP_CODE
AND PPR_PROCESS_TYPE_LOOKUP.LOOKUP_TYPE = 'IBY_PROCESS_TYPES'

Columns

Name
PAYMENT_SERVICE_REQUEST_ID
CALLING_APP_ID
APPLICATION_NAME
CALL_APP_PAY_SERVICE_REQ_CODE
CREATION_DATE
PAYMENT_SERVICE_REQUEST_STATUS
PPR_STATUS_MEANING
PROCESS_TYPE
PPR_ATTR_CAT
PPR_PROCESS_TYPE_MEANING