eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AR_PAYMENTS_INTERFACE_V

Object Details

Object Name:	AR_PAYMENTS_INTERFACE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_PAYMENTS_INTERFACE_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
TRANSMISSION_RECORD_ID	NUMBER	(15)
TRANSMISSION_ID	NUMBER	(15)
TRANSMISSION_NAME	VARCHAR2	(30)	Yes
TRANSMISSION_REQUEST_ID	NUMBER	(15)
CREATION_DATE	DATE
TRUNC_CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LOCKBOX_NUMBER	VARCHAR2	(30)
BATCH_NAME	VARCHAR2	(25)
ITEM_NUMBER	NUMBER
CHECK_NUMBER	VARCHAR2	(30)
OVERFLOW_SEQUENCE	NUMBER
RECORD_TYPE	VARCHAR2	(2)	Yes
RECORD_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes
STATUS	VARCHAR2	(30)
COMMENTS	VARCHAR2	(240)
ORIGINATION	VARCHAR2	(25)
DESTINATION_ACCOUNT	VARCHAR2	(25)
DEPOSIT_DATE	DATE
GL_DATE	DATE
DEPOSIT_TIME	VARCHAR2	(8)
CURRENCY_CODE	VARCHAR2	(15)
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE	NUMBER
TRANSMISSION_RECORD_COUNT	NUMBER	(15)
TRANSMISSION_AMOUNT	NUMBER
LOCKBOX_BATCH_COUNT	NUMBER
LOCKBOX_AMOUNT	NUMBER
LOCKBOX_RECORD_COUNT	NUMBER
BATCH_RECORD_COUNT	NUMBER	(15)
BATCH_AMOUNT	NUMBER
TRANSFERRED_RECEIPT_COUNT	NUMBER
TRANSFERRED_RECEIPT_AMOUNT	NUMBER
OVERFLOW_INDICATOR	VARCHAR2	(1)
SPECIAL_TYPE	VARCHAR2	(20)
RECEIPT_DATE	DATE
RECEIPT_METHOD_ID	NUMBER	(15)
RECEIPT_METHOD	VARCHAR2	(30)
REMITTANCE_AMOUNT	NUMBER
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_NUMBER	VARCHAR2	(30)
CUSTOMER_SITE_USE_ID	NUMBER	(15)
BILL_TO_LOCATION	VARCHAR2	(40)
TRANSIT_ROUTING_NUMBER	VARCHAR2	(25)
CUSTOMER_BANK_ACCOUNT_ID	NUMBER	(15)
ACCOUNT	VARCHAR2	(30)
AMOUNT_APPLIED1	NUMBER
INVOICE1	VARCHAR2	(50)
INVOICE1_INSTALLMENT	NUMBER
INVOICE1_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED2	NUMBER
INVOICE2	VARCHAR2	(50)
INVOICE2_INSTALLMENT	NUMBER
INVOICE2_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED3	NUMBER
INVOICE3	VARCHAR2	(50)
INVOICE3_INSTALLMENT	NUMBER
INVOICE3_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED4	NUMBER
INVOICE4	VARCHAR2	(50)
INVOICE4_INSTALLMENT	NUMBER
INVOICE4_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED5	NUMBER
INVOICE5	VARCHAR2	(50)
INVOICE5_INSTALLMENT	NUMBER
INVOICE5_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED6	NUMBER
INVOICE6	VARCHAR2	(50)
INVOICE6_INSTALLMENT	NUMBER
INVOICE6_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED7	NUMBER
INVOICE7	VARCHAR2	(50)
INVOICE7_INSTALLMENT	NUMBER
INVOICE7_STATUS	VARCHAR2	(30)
AMOUNT_APPLIED8	NUMBER
INVOICE8	VARCHAR2	(50)
INVOICE8_INSTALLMENT	NUMBER
INVOICE8_STATUS	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
CUSTOMER_NAME	VARCHAR2	(50)
CUSTOMER_NAME_PHONETIC	VARCHAR2	(320)
CUSTOMER_NAME_ALT	VARCHAR2	(320)
CUSTOMER_BANK_NAME	VARCHAR2	(320)
CUSTOMER_BANK_BRANCH_NAME	VARCHAR2	(320)
REMITTANCE_BANK_NAME	VARCHAR2	(320)
REMITTANCE_BANK_BRANCH_NAME	VARCHAR2	(320)
MATCHING1_DATE	DATE
MATCHING2_DATE	DATE
MATCHING3_DATE	DATE
MATCHING4_DATE	DATE
MATCHING5_DATE	DATE
MATCHING6_DATE	DATE
MATCHING7_DATE	DATE
MATCHING8_DATE	DATE
MATCH_RESOLVED_USING	VARCHAR2	(30)
AMOUNT_APPLIED_FROM1	NUMBER
AMOUNT_APPLIED_FROM2	NUMBER
AMOUNT_APPLIED_FROM3	NUMBER
AMOUNT_APPLIED_FROM4	NUMBER
AMOUNT_APPLIED_FROM5	NUMBER
AMOUNT_APPLIED_FROM6	NUMBER
AMOUNT_APPLIED_FROM7	NUMBER
AMOUNT_APPLIED_FROM8	NUMBER
INVOICE_CURRENCY_CODE1	VARCHAR2	(15)
INVOICE_CURRENCY_CODE2	VARCHAR2	(15)
INVOICE_CURRENCY_CODE3	VARCHAR2	(15)
INVOICE_CURRENCY_CODE4	VARCHAR2	(15)
INVOICE_CURRENCY_CODE5	VARCHAR2	(15)
INVOICE_CURRENCY_CODE6	VARCHAR2	(15)
INVOICE_CURRENCY_CODE7	VARCHAR2	(15)
INVOICE_CURRENCY_CODE8	VARCHAR2	(15)
TRANS_TO_RECEIPT_RATE1	NUMBER
TRANS_TO_RECEIPT_RATE2	NUMBER
TRANS_TO_RECEIPT_RATE3	NUMBER
TRANS_TO_RECEIPT_RATE4	NUMBER
TRANS_TO_RECEIPT_RATE5	NUMBER
TRANS_TO_RECEIPT_RATE6	NUMBER
TRANS_TO_RECEIPT_RATE7	NUMBER
TRANS_TO_RECEIPT_RATE8	NUMBER
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRANSACTION_CODE1	VARCHAR2	(30)
USSGL_TRANSACTION_CODE2	VARCHAR2	(30)
USSGL_TRANSACTION_CODE3	VARCHAR2	(30)
USSGL_TRANSACTION_CODE4	VARCHAR2	(30)
USSGL_TRANSACTION_CODE5	VARCHAR2	(30)
USSGL_TRANSACTION_CODE6	VARCHAR2	(30)
USSGL_TRANSACTION_CODE7	VARCHAR2	(30)
USSGL_TRANSACTION_CODE8	VARCHAR2	(30)
APPLICATION_NOTES	VARCHAR2	(2000)
ORG_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

APPS.AR_PAYMENTS_INTERFACE_V references the following:

APPS: AR_PAYMENTS_INTERFACE; AR_TRANSMISSIONS; AR_TRANS_RECORD_FORMATS; HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.AR_PAYMENTS_INTERFACE_V is not referenced by any database object