View: IBY_PAY_REQUEST_SEC_V

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

View Text

SELECT S.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, S.CALLING_APP_ID CALLING_APP_ID
, S.CALL_APP_PAY_SERVICE_REQ_CODE CALL_APP_PAY_SERVICE_REQ_CODE
, S.PAYMENT_SERVICE_REQUEST_STATUS PAYMENT_SERVICE_REQUEST_STATUS
, S.PROCESS_TYPE PROCESS_TYPE
, S.ALLOW_ZERO_PAYMENTS_FLAG ALLOW_ZERO_PAYMENTS_FLAG
, S.CREATED_BY CREATED_BY
, S.CREATION_DATE CREATION_DATE
, S.LAST_UPDATED_BY LAST_UPDATED_BY
, S.LAST_UPDATE_DATE LAST_UPDATE_DATE
, S.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, S.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, S.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, S.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, S.MAXIMUM_PAYMENT_AMOUNT MAXIMUM_PAYMENT_AMOUNT
, S.MINIMUM_PAYMENT_AMOUNT MINIMUM_PAYMENT_AMOUNT
, S.DOCUMENT_REJECTION_LEVEL_CODE DOCUMENT_REJECTION_LEVEL_CODE
, S.PAYMENT_REJECTION_LEVEL_CODE PAYMENT_REJECTION_LEVEL_CODE
, S.REQUIRE_PROP_PMTS_REVIEW_FLAG REQUIRE_PROP_PMTS_REVIEW_FLAG
, S.ORG_TYPE ORG_TYPE
, S.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1 ATTRIBUTE1
, S.ATTRIBUTE2 ATTRIBUTE2
, S.ATTRIBUTE3 ATTRIBUTE3
, S.ATTRIBUTE4 ATTRIBUTE4
, S.ATTRIBUTE5 ATTRIBUTE5
, S.ATTRIBUTE6 ATTRIBUTE6
, S.ATTRIBUTE7 ATTRIBUTE7
, S.ATTRIBUTE8 ATTRIBUTE8
, S.ATTRIBUTE9 ATTRIBUTE9
, S.ATTRIBUTE10 ATTRIBUTE10
, S.ATTRIBUTE11 ATTRIBUTE11
, S.ATTRIBUTE12 ATTRIBUTE12
, S.ATTRIBUTE13 ATTRIBUTE13
, S.ATTRIBUTE14 ATTRIBUTE14
, S.ATTRIBUTE15 ATTRIBUTE15
FROM IBY_PAY_SERVICE_REQUESTS S
WHERE EXISTS ( SELECT PO.ORG_ID
FROM IBY_PROCESS_ORGS PO
WHERE PO.OBJECT_ID = S.PAYMENT_SERVICE_REQUEST_ID
AND PO.OBJECT_TYPE = 'PAYMENT_REQUEST'
AND (PO.ORG_ID
, PO.ORG_TYPE) IN ( SELECT UO.ORGANIZATION_ID
, UO.ORGANIZATION_TYPE
FROM CE_SECURITY_PROFILES_V UO) )
AND EXISTS ( SELECT FS.PAYMENT_FUNCTION
FROM IBY_PROCESS_FUNCTIONS FS
WHERE FS.OBJECT_ID = S.PAYMENT_SERVICE_REQUEST_ID
AND FS.OBJECT_TYPE = 'PAYMENT_REQUEST'
AND FS.PAYMENT_FUNCTION IN ( SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU) )

Columns