View: IBY_PAYMENTS_SEC_V

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

View Text

SELECT IBY_PAY.PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER
, IBY_PAY.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, IBY_PAY.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID
, IBY_PAY.DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE
, IBY_PAY.DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE
, IBY_PAY.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, IBY_PAY.URI_CHECK_DIGIT URI_CHECK_DIGIT
, IBY_PAY.BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE
, IBY_PAY.BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE
, IBY_PAY.PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1
, IBY_PAY.PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2
, IBY_PAY.PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3
, IBY_PAY.BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, IBY_PAY.MATURITY_DATE MATURITY_DATE
, IBY_PAY.PAYMENT_DUE_DATE PAYMENT_DUE_DATE
, IBY_PAY.STOP_REQUEST_PLACED_FLAG STOP_REQUEST_PLACED_FLAG
, IBY_PAY.STOP_REQUEST_REASON STOP_REQUEST_REASON
, IBY_PAY.STOP_REQUEST_PLACED_BY STOP_REQUEST_PLACED_BY
, IBY_PAY.STOP_REQUEST_DATE STOP_REQUEST_DATE
, IBY_PAY.STOP_REQUEST_REFERENCE STOP_REQUEST_REFERENCE
, IBY_PAY.STOP_RELEASED_FLAG STOP_RELEASED_FLAG
, IBY_PAY.STOP_RELEASE_REASON STOP_RELEASE_REASON
, IBY_PAY.STOP_RELEASED_BY STOP_RELEASED_BY
, IBY_PAY.STOP_RELEASE_DATE STOP_RELEASE_DATE
, IBY_PAY.STOP_RELEASE_REFERENCE STOP_RELEASE_REFERENCE
, IBY_PAY.STOP_CONFIRMED_FLAG STOP_CONFIRMED_FLAG
, IBY_PAY.STOP_CONFIRM_REASON STOP_CONFIRM_REASON
, IBY_PAY.STOP_CONFIRMED_BY STOP_CONFIRMED_BY
, IBY_PAY.STOP_CONFIRM_DATE STOP_CONFIRM_DATE
, IBY_PAY.STOP_CONFIRM_REFERENCE STOP_CONFIRM_REFERENCE
, IBY_PAY.VOID_REASON VOID_REASON
, IBY_PAY.VOIDED_BY VOIDED_BY
, IBY_PAY.VOID_DATE VOID_DATE
, IBY_PAY.REMIT_TO_LOCATION_ID
, IBY_PAY.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IBY_PAY.ATTRIBUTE1 ATTRIBUTE1
, IBY_PAY.ATTRIBUTE2 ATTRIBUTE2
, IBY_PAY.ATTRIBUTE3 ATTRIBUTE3
, IBY_PAY.ATTRIBUTE4 ATTRIBUTE4
, IBY_PAY.ATTRIBUTE5 ATTRIBUTE5
, IBY_PAY.ATTRIBUTE6 ATTRIBUTE6
, IBY_PAY.ATTRIBUTE7 ATTRIBUTE7
, IBY_PAY.ATTRIBUTE8 ATTRIBUTE8
, IBY_PAY.ATTRIBUTE9 ATTRIBUTE9
, IBY_PAY.ATTRIBUTE10 ATTRIBUTE10
, IBY_PAY.ATTRIBUTE11 ATTRIBUTE11
, IBY_PAY.ATTRIBUTE12 ATTRIBUTE12
, IBY_PAY.ATTRIBUTE13 ATTRIBUTE13
, IBY_PAY.ATTRIBUTE14 ATTRIBUTE14
, IBY_PAY.ATTRIBUTE15 ATTRIBUTE15
, IBY_PAY.PAYMENT_ID PAYMENT_ID
, IBY_PAY.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, IBY_PAY.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, IBY_PAY.PROCESS_TYPE PROCESS_TYPE
, IBY_PAY.PAYMENT_STATUS PAYMENT_STATUS
, IBY_PAY.PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG
, IBY_PAY.PAYMENT_FUNCTION PAYMENT_FUNCTION
, IBY_PAY.PAYMENT_AMOUNT PAYMENT_AMOUNT
, IBY_PAY.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, IBY_PAY.SEPARATE_REMIT_ADVICE_REQ_FLAG SEPARATE_REMIT_ADVICE_REQ_FLAG
, IBY_PAY.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, IBY_PAY.PAYEE_PARTY_ID PAYEE_PARTY_ID
, IBY_PAY.PARTY_SITE_ID PARTY_SITE_ID
, IBY_PAY.DECLARE_PAYMENT_FLAG DECLARE_PAYMENT_FLAG
, IBY_PAY.DECLARATION_AMOUNT DECLARATION_AMOUNT
, IBY_PAY.DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE
, IBY_PAY.DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN
, IBY_PAY.PAYMENT_DETAILS PAYMENT_DETAILS
, IBY_PAY.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, IBY_PAY.BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, IBY_PAY.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, IBY_PAY.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, IBY_PAY.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, IBY_PAY.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, IBY_PAY.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, IBY_PAY.PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
, IBY_PAY.ORG_TYPE ORG_TYPE
, IBY_PAY.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, IBY_PAY.EXT_PAYEE_ID EXT_PAYEE_ID
, IBY_PAY.ORG_ID ORG_ID
, IBY_PAY.PREGROUPED_PAYMENT_FLAG PREGROUPED_PAYMENT_FLAG
, IBY_PAY.CREATED_BY CREATED_BY
, IBY_PAY.CREATION_DATE CREATION_DATE
, IBY_PAY.LAST_UPDATED_BY LAST_UPDATED_BY
, IBY_PAY.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IBY_PAY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IBY_PAY.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IBY_PAY.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, IBY_PAY.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, IBY_PAY.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, IBY_PAY.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, IBY_PAY.PAYMENT_DATE PAYMENT_DATE
, IBY_PAY.ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, IBY_PAY.COMPLETED_PMTS_GROUP_ID COMPLETED_PMTS_GROUP_ID
, IBY_PAY.EXT_BRANCH_NUMBER EXT_BRANCH_NUMBER
, IBY_PAY.EXT_BANK_NUMBER EXT_BANK_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NAME
, IBY_PAY.EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_TYPE
, IBY_PAY.EXT_BANK_ACCOUNT_IBAN_NUMBER EXT_BANK_ACCOUNT_IBAN_NUMBER
, IBY_PAY.PAYEE_NAME PAYEE_NAME
, IBY_PAY.PAYEE_ADDRESS1 PAYEE_ADDRESS1
, IBY_PAY.PAYEE_ADDRESS2 PAYEE_ADDRESS2
, IBY_PAY.PAYEE_ADDRESS3 PAYEE_ADDRESS3
, IBY_PAY.PAYEE_ADDRESS4 PAYEE_ADDRESS4
, IBY_PAY.PAYEE_CITY PAYEE_CITY
, IBY_PAY.PAYEE_POSTAL_CODE PAYEE_POSTAL_CODE
, IBY_PAY.PAYEE_STATE PAYEE_STATE
, IBY_PAY.PAYEE_PROVINCE PAYEE_PROVINCE
, IBY_PAY.PAYEE_COUNTY PAYEE_COUNTY
, IBY_PAY.PAYEE_COUNTRY PAYEE_COUNTRY
FROM IBY_PAYMENTS_ALL IBY_PAY
WHERE (IBY_PAY.ORG_ID
, IBY_PAY.ORG_TYPE) IN (SELECT CE.ORGANIZATION_ID
, CE.ORGANIZATION_TYPE
FROM CE_SECURITY_PROFILES_V CE)
AND IBY_PAY.PAYMENT_FUNCTION IN (SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU)

Columns