VIEW: APPS.IBY_DOCS_PAYABLE_SEC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)