View: AR_PAYMENTS_INTERFACE_V

Product:	AR - Receivables
Description:	Payments Interface used in the maintain transmission data form
Implementation/DBA Data:	APPS.AR_PAYMENTS_INTERFACE_V

View Text

SELECT I.ROWID ROW_ID
, I.TRANSMISSION_RECORD_ID TRANSMISSION_RECORD_ID
, I.TRANSMISSION_ID TRANSMISSION_ID
, T.TRANSMISSION_NAME TRANSMISSION_NAME
, I.TRANSMISSION_REQUEST_ID TRANSMISSION_REQUEST_ID
, I.CREATION_DATE CREATION_DATE
, TRUNC(I.CREATION_DATE) TRUNC_CREATION_DATE
, I.CREATED_BY CREATED_BY
, I.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, I.LAST_UPDATED_BY LAST_UPDATED_BY
, I.LAST_UPDATE_DATE LAST_UPDATE_DATE
, I.LOCKBOX_NUMBER LOCKBOX_NUMBER
, I.BATCH_NAME BATCH_NAME
, I.ITEM_NUMBER ITEM_NUMBER
, I.CHECK_NUMBER CHECK_NUMBER
, I.OVERFLOW_SEQUENCE OVERFLOW_SEQUENCE
, I.RECORD_TYPE RECORD_TYPE
, F.RECORD_TYPE_LOOKUP_CODE RECORD_TYPE_LOOKUP_CODE
, I.STATUS STATUS
, I.COMMENTS COMMENTS
, I.ORIGINATION ORIGINATION
, I.DESTINATION_ACCOUNT DESTINATION_ACCOUNT
, I.DEPOSIT_DATE DEPOSIT_DATE
, I.GL_DATE GL_DATE
, I.DEPOSIT_TIME DEPOSIT_TIME
, I.CURRENCY_CODE CURRENCY_CODE
, I.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, I.EXCHANGE_RATE EXCHANGE_RATE
, I.TRANSMISSION_RECORD_COUNT TRANSMISSION_RECORD_COUNT
, I.TRANSMISSION_AMOUNT TRANSMISSION_AMOUNT
, I.LOCKBOX_BATCH_COUNT LOCKBOX_BATCH_COUNT
, I.LOCKBOX_AMOUNT LOCKBOX_AMOUNT
, I.LOCKBOX_RECORD_COUNT LOCKBOX_RECORD_COUNT
, I.BATCH_RECORD_COUNT BATCH_RECORD_COUNT
, I.BATCH_AMOUNT BATCH_AMOUNT
, I.TRANSFERRED_RECEIPT_COUNT TRANSFERRED_RECEIPT_COUNT
, I.TRANSFERRED_RECEIPT_AMOUNT TRANSFERRED_RECEIPT_AMOUNT
, I.OVERFLOW_INDICATOR OVERFLOW_INDICATOR
, I.SPECIAL_TYPE SPECIAL_TYPE
, I.RECEIPT_DATE RECEIPT_DATE
, I.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, I.RECEIPT_METHOD RECEIPT_METHOD
, I.REMITTANCE_AMOUNT REMITTANCE_AMOUNT
, I.CUSTOMER_ID CUSTOMER_ID
, I.CUSTOMER_NUMBER CUSTOMER_NUMBER
, I.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, I.BILL_TO_LOCATION BILL_TO_LOCATION
, I.TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER
, I.CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, I.ACCOUNT ACCOUNT
, I.AMOUNT_APPLIED1 AMOUNT_APPLIED1
, I.INVOICE1 INVOICE1
, I.INVOICE1_INSTALLMENT INVOICE1_INSTALLMENT
, I.INVOICE1_STATUS INVOICE1_STATUS
, I.AMOUNT_APPLIED2 AMOUNT_APPLIED2
, I.INVOICE2 INVOICE2
, I.INVOICE2_INSTALLMENT INVOICE2_INSTALLMENT
, I.INVOICE2_STATUS INVOICE2_STATUS
, I.AMOUNT_APPLIED3 AMOUNT_APPLIED3
, I.INVOICE3 INVOICE3
, I.INVOICE3_INSTALLMENT INVOICE3_INSTALLMENT
, I.INVOICE3_STATUS INVOICE3_STATUS
, I.AMOUNT_APPLIED4 AMOUNT_APPLIED4
, I.INVOICE4 INVOICE4
, I.INVOICE4_INSTALLMENT INVOICE4_INSTALLMENT
, I.INVOICE4_STATUS INVOICE4_STATUS
, I.AMOUNT_APPLIED5 AMOUNT_APPLIED5
, I.INVOICE5 INVOICE5
, I.INVOICE5_INSTALLMENT INVOICE5_INSTALLMENT
, I.INVOICE5_STATUS INVOICE5_STATUS
, I.AMOUNT_APPLIED6 AMOUNT_APPLIED6
, I.INVOICE6 INVOICE6
, I.INVOICE6_INSTALLMENT INVOICE6_INSTALLMENT
, I.INVOICE6_STATUS INVOICE6_STATUS
, I.AMOUNT_APPLIED7 AMOUNT_APPLIED7
, I.INVOICE7 INVOICE7
, I.INVOICE7_INSTALLMENT INVOICE7_INSTALLMENT
, I.INVOICE7_STATUS INVOICE7_STATUS
, I.AMOUNT_APPLIED8 AMOUNT_APPLIED8
, I.INVOICE8 INVOICE8
, I.INVOICE8_INSTALLMENT INVOICE8_INSTALLMENT
, I.INVOICE8_STATUS INVOICE8_STATUS
, I.ATTRIBUTE1 ATTRIBUTE1
, I.ATTRIBUTE2 ATTRIBUTE2
, I.ATTRIBUTE3 ATTRIBUTE3
, I.ATTRIBUTE4 ATTRIBUTE4
, I.ATTRIBUTE5 ATTRIBUTE5
, I.ATTRIBUTE6 ATTRIBUTE6
, I.ATTRIBUTE7 ATTRIBUTE7
, I.ATTRIBUTE8 ATTRIBUTE8
, I.ATTRIBUTE9 ATTRIBUTE9
, I.ATTRIBUTE10 ATTRIBUTE10
, I.ATTRIBUTE11 ATTRIBUTE11
, I.ATTRIBUTE12 ATTRIBUTE12
, I.ATTRIBUTE13 ATTRIBUTE13
, I.ATTRIBUTE14 ATTRIBUTE14
, I.ATTRIBUTE15 ATTRIBUTE15
, I.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) CUSTOMER_NAME_PHONETIC
, I.CUSTOMER_NAME_ALT CUSTOMER_NAME_ALT
, I.CUSTOMER_BANK_NAME CUSTOMER_BANK_NAME
, I.CUSTOMER_BANK_BRANCH_NAME CUSTOMER_BANK_BRANCH_NAME
, I.REMITTANCE_BANK_NAME REMITTANCE_BANK_NAME
, I.REMITTANCE_BANK_BRANCH_NAME REMITTANCE_BANK_BRANCH_NAME
, I.MATCHING1_DATE
, I.MATCHING2_DATE
, I.MATCHING3_DATE
, I.MATCHING4_DATE
, I.MATCHING5_DATE
, I.MATCHING6_DATE
, I.MATCHING7_DATE
, I.MATCHING8_DATE
, I.MATCH_RESOLVED_USING
, I.AMOUNT_APPLIED_FROM1
, I.AMOUNT_APPLIED_FROM2
, I.AMOUNT_APPLIED_FROM3
, I.AMOUNT_APPLIED_FROM4
, I.AMOUNT_APPLIED_FROM5
, I.AMOUNT_APPLIED_FROM6
, I.AMOUNT_APPLIED_FROM7
, I.AMOUNT_APPLIED_FROM8
, I.INVOICE_CURRENCY_CODE1
, I.INVOICE_CURRENCY_CODE2
, I.INVOICE_CURRENCY_CODE3
, I.INVOICE_CURRENCY_CODE4
, I.INVOICE_CURRENCY_CODE5
, I.INVOICE_CURRENCY_CODE6
, I.INVOICE_CURRENCY_CODE7
, I.INVOICE_CURRENCY_CODE8
, I.TRANS_TO_RECEIPT_RATE1
, I.TRANS_TO_RECEIPT_RATE2
, I.TRANS_TO_RECEIPT_RATE3
, I.TRANS_TO_RECEIPT_RATE4
, I.TRANS_TO_RECEIPT_RATE5
, I.TRANS_TO_RECEIPT_RATE6
, I.TRANS_TO_RECEIPT_RATE7
, I.TRANS_TO_RECEIPT_RATE8
, I.USSGL_TRANSACTION_CODE
, I.USSGL_TRANSACTION_CODE1
, I.USSGL_TRANSACTION_CODE2
, I.USSGL_TRANSACTION_CODE3
, I.USSGL_TRANSACTION_CODE4
, I.USSGL_TRANSACTION_CODE5
, I.USSGL_TRANSACTION_CODE6
, I.USSGL_TRANSACTION_CODE7
, I.USSGL_TRANSACTION_CODE8
, I.APPLICATION_NOTES
, I.ORG_ID
FROM AR_PAYMENTS_INTERFACE I
, AR_TRANSMISSIONS T
, AR_TRANS_RECORD_FORMATS F
, HZ_CUST_ACCOUNTS C
, HZ_PARTIES PARTY
WHERE I.TRANSMISSION_ID = T.TRANSMISSION_ID
AND T.REQUESTED_TRANS_FORMAT_ID = F.TRANSMISSION_FORMAT_ID
AND I.RECORD_TYPE = F.RECORD_IDENTIFIER
AND I.CUSTOMER_ID = C.CUST_ACCOUNT_ID(+)
AND C.PARTY_ID = PARTY.PARTY_ID(+)

Columns