VIEW: APPS.AR_PAYMENTS_INTERFACE_V

Source

View Text - Preformatted

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 /* 6829399 */ , 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(+)

View Text - HTML Formatted

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 /* 6829399 */
, 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(+)