View: IBY_DOCS_PAYABLE_SEC_V

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

View Text

SELECT IBY_DOCS.PAY_PROC_TRXN_TYPE_CODE PAY_PROC_TRXN_TYPE_CODE
, IBY_DOCS.CALLING_APP_ID CALLING_APP_ID
, IBY_DOCS.CALLING_APP_DOC_REF_NUMBER CALLING_APP_DOC_REF_NUMBER
, IBY_DOCS.DOCUMENT_PAYABLE_ID DOCUMENT_PAYABLE_ID
, IBY_DOCS.PAYMENT_FUNCTION PAYMENT_FUNCTION
, IBY_DOCS.PAYMENT_DATE PAYMENT_DATE
, IBY_DOCS.DOCUMENT_DATE DOCUMENT_DATE
, IBY_DOCS.DOCUMENT_TYPE DOCUMENT_TYPE
, IBY_DOCS.DOCUMENT_STATUS DOCUMENT_STATUS
, IBY_DOCS.DOCUMENT_CURRENCY_CODE DOCUMENT_CURRENCY_CODE
, IBY_DOCS.DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, IBY_DOCS.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, IBY_DOCS.PAYMENT_AMOUNT PAYMENT_AMOUNT
, IBY_DOCS.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, IBY_DOCS.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, IBY_DOCS.STRAIGHT_THROUGH_FLAG STRAIGHT_THROUGH_FLAG
, IBY_DOCS.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, IBY_DOCS.EXT_PAYEE_ID EXT_PAYEE_ID
, IBY_DOCS.PAYEE_PARTY_ID PAYEE_PARTY_ID
, IBY_DOCS.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, IBY_DOCS.ORG_ID ORG_ID
, IBY_DOCS.CREATED_BY CREATED_BY
, IBY_DOCS.CREATION_DATE CREATION_DATE
, IBY_DOCS.LAST_UPDATED_BY LAST_UPDATED_BY
, IBY_DOCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IBY_DOCS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF1
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF2
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF3
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF4
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_UNIQUE_REF5
, IBY_DOCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IBY_DOCS.PARTY_SITE_ID PARTY_SITE_ID
, IBY_DOCS.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, IBY_DOCS.ORG_TYPE ORG_TYPE
, IBY_DOCS.ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, IBY_DOCS.PO_NUMBER PO_NUMBER
, IBY_DOCS.DOCUMENT_DESCRIPTION DOCUMENT_DESCRIPTION
, IBY_DOCS.DOCUMENT_CURRENCY_TAX_AMOUNT DOCUMENT_CURRENCY_TAX_AMOUNT
, IBY_DOCS.DOCUMENT_CURR_CHARGE_AMOUNT DOCUMENT_CURR_CHARGE_AMOUNT
, IBY_DOCS.AMOUNT_WITHHELD AMOUNT_WITHHELD
, IBY_DOCS.PAYMENT_CURR_DISCOUNT_TAKEN PAYMENT_CURR_DISCOUNT_TAKEN
, IBY_DOCS.DISCOUNT_DATE DISCOUNT_DATE
, IBY_DOCS.PAYMENT_DUE_DATE PAYMENT_DUE_DATE
, IBY_DOCS.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, IBY_DOCS.PAYMENT_ID PAYMENT_ID
, IBY_DOCS.FORMATTING_PAYMENT_ID FORMATTING_PAYMENT_ID
, IBY_DOCS.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, IBY_DOCS.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, IBY_DOCS.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, IBY_DOCS.INTEREST_RATE INTEREST_RATE
, IBY_DOCS.PAYMENT_GROUPING_NUMBER PAYMENT_GROUPING_NUMBER
, IBY_DOCS.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, IBY_DOCS.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, IBY_DOCS.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, IBY_DOCS.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, IBY_DOCS.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, IBY_DOCS.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, IBY_DOCS.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, IBY_DOCS.URI_CHECK_DIGIT URI_CHECK_DIGIT
, IBY_DOCS.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, IBY_DOCS.PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE
, IBY_DOCS.DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID
, IBY_DOCS.DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE
, IBY_DOCS.DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE
, IBY_DOCS.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, IBY_DOCS.REMIT_TO_LOCATION_ID REMIT_TO_LOCATION_ID
, IBY_DOCS.ALLOW_REMOVING_DOCUMENT_FLAG ALLOW_REMOVING_DOCUMENT_FLAG
, IBY_DOCS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IBY_DOCS.ATTRIBUTE1 ATTRIBUTE1
, IBY_DOCS.ATTRIBUTE2 ATTRIBUTE2
, IBY_DOCS.ATTRIBUTE3 ATTRIBUTE3
, IBY_DOCS.ATTRIBUTE4 ATTRIBUTE4
, IBY_DOCS.ATTRIBUTE5 ATTRIBUTE5
, IBY_DOCS.ATTRIBUTE6 ATTRIBUTE6
, IBY_DOCS.ATTRIBUTE7 ATTRIBUTE7
, IBY_DOCS.ATTRIBUTE8 ATTRIBUTE8
, IBY_DOCS.ATTRIBUTE9 ATTRIBUTE9
, IBY_DOCS.ATTRIBUTE10 ATTRIBUTE10
, IBY_DOCS.ATTRIBUTE11 ATTRIBUTE11
, IBY_DOCS.ATTRIBUTE12 ATTRIBUTE12
, IBY_DOCS.ATTRIBUTE13 ATTRIBUTE13
, IBY_DOCS.ATTRIBUTE14 ATTRIBUTE14
, IBY_DOCS.ATTRIBUTE15 ATTRIBUTE15
, IBY_DOCS.COMPLETED_PMTS_GROUP_ID COMPLETED_PMTS_GROUP_ID
, IBY_DOCS.REJECTED_DOCS_GROUP_ID REJECTED_DOCS_GROUP_ID
FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS
WHERE (IBY_DOCS.ORG_ID
, IBY_DOCS.ORG_TYPE) IN (SELECT CE.ORGANIZATION_ID
, CE.ORGANIZATION_TYPE
FROM CE_SECURITY_PROFILES_V CE)
AND IBY_DOCS.PAYMENT_FUNCTION IN (SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU)

Columns