View: IBY_PAY_INSTRUCTIONS_SEC_V

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

View Text

SELECT I.ATTRIBUTE14 ATTRIBUTE14
, I.ATTRIBUTE15 ATTRIBUTE15
, I.REGULATORY_REPORT_CREATED_FLAG REGULATORY_REPORT_CREATED_FLAG
, I.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, I.PAYMENT_COUNT PAYMENT_COUNT
, I.CREATED_BY CREATED_BY
, I.CREATION_DATE CREATION_DATE
, I.REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG
, I.ATTRIBUTE13 ATTRIBUTE13
, I.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, I.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, I.PROCESS_TYPE PROCESS_TYPE
, I.PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS
, I.PAYMENTS_COMPLETE_CODE PAYMENTS_COMPLETE_CODE
, I.GENERATE_SEP_REMIT_ADVICE_FLAG GENERATE_SEP_REMIT_ADVICE_FLAG
, I.ATTRIBUTE8 ATTRIBUTE8
, I.ATTRIBUTE9 ATTRIBUTE9
, I.ATTRIBUTE10 ATTRIBUTE10
, I.ATTRIBUTE11 ATTRIBUTE11
, I.ATTRIBUTE12 ATTRIBUTE12
, I.LAST_UPDATED_BY LAST_UPDATED_BY
, I.LAST_UPDATE_DATE LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, I.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, I.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, I.PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE
, I.TRANSMISSION_DATE TRANSMISSION_DATE
, I.ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE
, I.COMMENTS COMMENTS
, I.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, I.ORG_ID ORG_ID
, I.ORG_TYPE ORG_TYPE
, I.PAYMENT_DATE PAYMENT_DATE
, I.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, I.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, I.PAYMENT_FUNCTION PAYMENT_FUNCTION
, I.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, I.BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, I.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1 ATTRIBUTE1
, I.ATTRIBUTE2 ATTRIBUTE2
, I.ATTRIBUTE3 ATTRIBUTE3
, I.ATTRIBUTE4 ATTRIBUTE4
, I.ATTRIBUTE5 ATTRIBUTE5
, I.ATTRIBUTE6 ATTRIBUTE6
, I.ATTRIBUTE7 ATTRIBUTE7
, I.POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG
, I.RFC_IDENTIFIER RFC_IDENTIFIER
, I.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, I.PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID
, I.PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG
, I.TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG
, I.PRINTER_NAME PRINTER_NAME
FROM IBY_PAY_INSTRUCTIONS_ALL I
WHERE EXISTS ( SELECT PO.ORG_ID
FROM IBY_PROCESS_ORGS PO
WHERE PO.OBJECT_ID = I.PAYMENT_INSTRUCTION_ID
AND PO.OBJECT_TYPE = 'PAYMENT_INSTRUCTION'
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 = I.PAYMENT_INSTRUCTION_ID
AND FS.OBJECT_TYPE = 'PAYMENT_INSTRUCTION'
AND FS.PAYMENT_FUNCTION IN ( SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU) )

Columns