VIEW: APPS.IBY_EXT_FD_PPR_1_0_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'