Product: | EC - e-Commerce Gateway |
---|---|
Description: | This view extracts invoices selected for payment to supportthe outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice I |
Implementation/DBA Data: | APPS.ECE_PYO_INVOICE_V |
SELECT IDPA.PAYMENT_ID PAYMENT_ID
, IPA.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, NULL PAY_SELECTED_CHECK_ID
, APS.SEGMENT1 VENDOR_NUM
, NULL CUSTOMER_NUM
, AI.INVOICE_NUM INVOICE_NUM
, IDPA.DOCUMENT_DATE INVOICE_DATE
, IDPA.DOCUMENT_DESCRIPTION INVOICE_DESCRIPTION
, IDPA.PAYMENT_AMOUNT PROPOSED_PAYMENT_AMOUNT
, IDPA.DOCUMENT_AMOUNT INVOICE_AMOUNT
, NULL DISCOUNT_AMOUNT
, NULL PRINT_SELECTED_CHECK_ID
, IDPA.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IDPA.ATTRIBUTE1 ATTRIBUTE1
, IDPA.ATTRIBUTE2 ATTRIBUTE2
, IDPA.ATTRIBUTE3 ATTRIBUTE3
, IDPA.ATTRIBUTE4 ATTRIBUTE4
, IDPA.ATTRIBUTE5 ATTRIBUTE5
, IDPA.ATTRIBUTE6 ATTRIBUTE6
, IDPA.ATTRIBUTE7 ATTRIBUTE7
, IDPA.ATTRIBUTE8 ATTRIBUTE8
, IDPA.ATTRIBUTE9 ATTRIBUTE9
, IDPA.ATTRIBUTE10 ATTRIBUTE10
, IDPA.ATTRIBUTE11 ATTRIBUTE11
, IDPA.ATTRIBUTE12 ATTRIBUTE12
, IDPA.ATTRIBUTE13 ATTRIBUTE13
, IDPA.ATTRIBUTE14 ATTRIBUTE14
, IDPA.ATTRIBUTE15 ATTRIBUTE15
, AI.GLOBAL_ATTRIBUTE_CATEGORY INV_GLOBAL_ATTRIBUTE_CATEGORY
, AI.GLOBAL_ATTRIBUTE1 INV_GLOBAL_ATTRIBUTE1
, AI.GLOBAL_ATTRIBUTE2 INV_GLOBAL_ATTRIBUTE2
, AI.GLOBAL_ATTRIBUTE3 INV_GLOBAL_ATTRIBUTE3
, AI.GLOBAL_ATTRIBUTE4 INV_GLOBAL_ATTRIBUTE4
, AI.GLOBAL_ATTRIBUTE5 INV_GLOBAL_ATTRIBUTE5
, AI.GLOBAL_ATTRIBUTE6 INV_GLOBAL_ATTRIBUTE6
, AI.GLOBAL_ATTRIBUTE7 INV_GLOBAL_ATTRIBUTE7
, AI.GLOBAL_ATTRIBUTE8 INV_GLOBAL_ATTRIBUTE8
, AI.GLOBAL_ATTRIBUTE9 INV_GLOBAL_ATTRIBUTE9
, AI.GLOBAL_ATTRIBUTE10 INV_GLOBAL_ATTRIBUTE10
, AI.GLOBAL_ATTRIBUTE11 INV_GLOBAL_ATTRIBUTE11
, AI.GLOBAL_ATTRIBUTE12 INV_GLOBAL_ATTRIBUTE12
, AI.GLOBAL_ATTRIBUTE13 INV_GLOBAL_ATTRIBUTE13
, AI.GLOBAL_ATTRIBUTE14 INV_GLOBAL_ATTRIBUTE14
, AI.GLOBAL_ATTRIBUTE15 INV_GLOBAL_ATTRIBUTE15
, AI.GLOBAL_ATTRIBUTE16 INV_GLOBAL_ATTRIBUTE16
, AI.GLOBAL_ATTRIBUTE17 INV_GLOBAL_ATTRIBUTE17
, AI.GLOBAL_ATTRIBUTE18 INV_GLOBAL_ATTRIBUTE18
, AI.GLOBAL_ATTRIBUTE19 INV_GLOBAL_ATTRIBUTE19
, AI.GLOBAL_ATTRIBUTE20 INV_GLOBAL_ATTRIBUTE20
, AI.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, AI.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, AI.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, AI.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, AI.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, AI.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, AI.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, AI.URI_CHECK_DIGIT URI_CHECK_DIGIT
, AI.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, AI.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, AI.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, AI.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
FROM IBY_DOCS_PAYABLE_ALL IDPA
, AP_INVOICES AI
, AP_SUPPLIERS APS
, AP_SUPPLIER_SITES APSS
, IBY_PAYMENTS_ALL IPA
WHERE IDPA.PAYMENT_ID = IPA.PAYMENT_ID
AND AI.INVOICE_ID(+) = IDPA.CALLING_APP_DOC_UNIQUE_REF2
AND IDPA.SUPPLIER_SITE_ID = APSS.VENDOR_SITE_ID (+)
AND APSS.VENDOR_ID = APS.VENDOR_ID (+)