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: AR.AR_RECEIPTS_REP_ITF#

Object Details

Object Name:	AR_RECEIPTS_REP_ITF#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQUEST_ID	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ORGANIZATION_NAME	VARCHAR2	(50)
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)
BATCH_ID	NUMBER	(15)
BATCH_NAME	VARCHAR2	(20)
CASH_RECEIPT_ID	NUMBER	(15)
RECEIPT_NUMBER	VARCHAR2	(30)
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
EXCHANGE_RATE	NUMBER
EXCHANGE_DATE	DATE
EXCHANGE_TYPE	VARCHAR2	(30)
DOC_SEQUENCE_NAME	VARCHAR2	(30)
DOC_SEQUENCE_VALUE	NUMBER
DEPOSIT_DATE	DATE
RECEIPT_DATE	DATE
RECEIPT_TYPE	VARCHAR2	(30)
RECEIPT_STATUS	VARCHAR2	(40)
MISC_PAYMENT_SOURCE	VARCHAR2	(30)
TAX_CODE	VARCHAR2	(50)
REFERENCE_TYPE	VARCHAR2	(30)
ANTICIPATED_CLEARING_DATE	DATE
BANK_NAME	VARCHAR2	(60)
BANK_NAME_ALT	VARCHAR2	(320)
BANK_BRANCH_NAME	VARCHAR2	(60)
BANK_BRANCH_NAME_ALT	VARCHAR2	(320)
BANK_NUMBER	VARCHAR2	(30)
BANK_BRANCH_NUMBER	VARCHAR2	(25)
BANK_ACCOUNT_NAME	VARCHAR2	(80)
BANK_ACCOUNT_NAME_ALT	VARCHAR2	(320)
BANK_ACCOUNT_CURRENCY	VARCHAR2	(15)
RECEIPT_METHOD	VARCHAR2	(30)
CASH_RECEIPT_HISTORY_ID	NUMBER	(15)
GL_DATE	DATE
RECEIPT_AMOUNT	NUMBER
RECEIPT_HISTORY_STATUS	VARCHAR2	(40)
ACCTD_RECEIPT_AMOUNT	NUMBER
FACTOR_DISCOUNT_AMOUNT	NUMBER
ACCTD_FACTOR_DISCOUNT_AMOUNT	NUMBER
ACCOUNT_CODE_COMBINATION_ID	NUMBER	(15)
DEBIT_ACCOUNT	VARCHAR2	(240)
DEBIT_ACCOUNT_DESC	VARCHAR2	(240)
DEBIT_BALANCING	VARCHAR2	(240)
DEBIT_BALANCING_DESC	VARCHAR2	(240)
DEBIT_NATACCT	VARCHAR2	(240)
DEBIT_NATACCT_DESC	VARCHAR2	(240)
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_NAME	VARCHAR2	(240)
CUSTOMER_NAME_ALT	VARCHAR2	(320)
CUSTOMER_NUMBER	VARCHAR2	(30)
RECEIVABLE_APPLICATION_ID	NUMBER	(15)
APPLY_DATE	DATE
APPLICATION_STATUS	VARCHAR2	(20)
AMOUNT_APPLIED_TO	NUMBER
AMOUNT_APPLIED_FROM	NUMBER
ACCTD_AMOUNT_APPLIED_TO	NUMBER
ACCTD_AMOUNT_APPLIED_FROM	NUMBER
EARNED_DISCOUNT_TAKEN	NUMBER
UNEARNED_DISCOUNT_TAKEN	NUMBER
ACCTD_EARNED_DISCOUNT_TAKEN	NUMBER
ACCTD_UNEARNED_DISCOUNT_TAKEN	NUMBER
APPLIED_CUSTOMER_TRX_ID	NUMBER	(15)
TRX_NUMBER	VARCHAR2	(30)
TRX_CURRENCY_CODE	VARCHAR2	(15)
TRX_DATE	DATE
TRX_AMOUNT	NUMBER
ACCTD_TRX_AMOUNT	NUMBER
RECEIPT_GAIN_LOSS	NUMBER
MISC_PERCENT	NUMBER
MISC_AMOUNT	NUMBER
BATCH_SOURCE	VARCHAR2	(50)
RELATED_CUSTOMER	VARCHAR2	(50)
ON_ACCOUNT_AMOUNT	NUMBER
UNAPP_AMOUNT	NUMBER
CLAIM_AMOUNT	NUMBER
PREPAY_AMOUNT	NUMBER
TOTAL_UNRESOLVED_AMOUNT	NUMBER
FORMAT_CURRENCY_CODE	VARCHAR2	(15)
ACTIVITY_NAME	VARCHAR2	(50)
ACCOUNT_NUMBER	VARCHAR2	(30)
ACCOUNTING_FLEXFIELD	VARCHAR2	(2000)
APPLICATION_REF_TYPE	VARCHAR2	(80)
APPLICATION_REF_NUMBER	VARCHAR2	(30)
AMOUNT_APPLIED	NUMBER
REMIT_BATCH_NAME	VARCHAR2	(20)

Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      BATCH_ID
,      BATCH_NAME
,      CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      RECEIPT_CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_TYPE
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      DEPOSIT_DATE
,      RECEIPT_DATE
,      RECEIPT_TYPE
,      RECEIPT_STATUS
,      MISC_PAYMENT_SOURCE
,      TAX_CODE
,      REFERENCE_TYPE
,      ANTICIPATED_CLEARING_DATE
,      BANK_NAME
,      BANK_NAME_ALT
,      BANK_BRANCH_NAME
,      BANK_BRANCH_NAME_ALT
,      BANK_NUMBER
,      BANK_BRANCH_NUMBER
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NAME_ALT
,      BANK_ACCOUNT_CURRENCY
,      RECEIPT_METHOD
,      CASH_RECEIPT_HISTORY_ID
,      GL_DATE
,      RECEIPT_AMOUNT
,      RECEIPT_HISTORY_STATUS
,      ACCTD_RECEIPT_AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      ACCTD_FACTOR_DISCOUNT_AMOUNT
,      ACCOUNT_CODE_COMBINATION_ID
,      DEBIT_ACCOUNT
,      DEBIT_ACCOUNT_DESC
,      DEBIT_BALANCING
,      DEBIT_BALANCING_DESC
,      DEBIT_NATACCT
,      DEBIT_NATACCT_DESC
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NAME_ALT
,      CUSTOMER_NUMBER
,      RECEIVABLE_APPLICATION_ID
,      APPLY_DATE
,      APPLICATION_STATUS
,      AMOUNT_APPLIED_TO
,      AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_AMOUNT_APPLIED_FROM
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      APPLIED_CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_CURRENCY_CODE
,      TRX_DATE
,      TRX_AMOUNT
,      ACCTD_TRX_AMOUNT
,      RECEIPT_GAIN_LOSS
,      MISC_PERCENT
,      MISC_AMOUNT
,      BATCH_SOURCE
,      RELATED_CUSTOMER
,      ON_ACCOUNT_AMOUNT
,      UNAPP_AMOUNT
,      CLAIM_AMOUNT
,      PREPAY_AMOUNT
,      TOTAL_UNRESOLVED_AMOUNT
,      FORMAT_CURRENCY_CODE
,      ACTIVITY_NAME
,      ACCOUNT_NUMBER
,      ACCOUNTING_FLEXFIELD
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_NUMBER
,      AMOUNT_APPLIED
,      REMIT_BATCH_NAME
FROM AR.AR_RECEIPTS_REP_ITF#;

Dependencies

[top of page]

AR.AR_RECEIPTS_REP_ITF# references the following:

AR: AR_RECEIPTS_REP_ITF

AR.AR_RECEIPTS_REP_ITF# is referenced by following:

APPS: AR_RECEIPTS_REP_ITF