IBY_EXT_FD_PPR_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

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 CREATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY

Query

SQL_Statement

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,PPR.CREATED_BY,PPR.LAST_UPDATE_DATE,PPR.LAST_UPDATE_LOGIN,PPR.LAST_UPDATED_BY 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'