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_ARCHIVE_CONTROL_DETAIL#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ARCHIVE_ID	VARCHAR2	(15)	Yes
PERIOD_NUMBER	NUMBER
PERIOD_NAME	VARCHAR2	(15)
INVOICES_CNT	NUMBER
CREDIT_MEMOS_CNT	NUMBER
DEBIT_MEMOS_CNT	NUMBER
CHARGEBACKS_CNT	NUMBER
DEPOSITS_CNT	NUMBER
ADJUSTMENTS_CNT	NUMBER
CASH_RECEIPTS_CNT	NUMBER
INVOICES_NO_REC_CNT	NUMBER
CREDIT_MEMOS_NO_REC_CNT	NUMBER
DEBIT_MEMOS_NO_REC_CNT	NUMBER
CHARGEBACKS_NO_REC_CNT	NUMBER
DEPOSITS_NO_REC_CNT	NUMBER
GUARANTEES_CNT	NUMBER
MISC_RECEIPTS_CNT	NUMBER
INVOICES_TOTAL	NUMBER
CREDIT_MEMOS_TOTAL	NUMBER
DEBIT_MEMOS_TOTAL	NUMBER
CHARGEBACKS_TOTAL	NUMBER
DEPOSITS_TOTAL	NUMBER
ADJUSTMENTS_TOTAL	NUMBER
CASH_RECEIPTS_TOTAL	NUMBER
DISCOUNTS_TOTAL	NUMBER
EXCHANGE_GAIN_LOSS_TOTAL	NUMBER
INVOICES_NO_REC_TOTAL	NUMBER
CREDIT_MEMOS_NO_REC_TOTAL	NUMBER
DEBIT_MEMOS_NO_REC_TOTAL	NUMBER
CHARGEBACKS_NO_REC_TOTAL	NUMBER
DEPOSITS_NO_REC_TOTAL	NUMBER
GUARANTEES_TOTAL	NUMBER
MISC_RECEIPTS_TOTAL	NUMBER

Query Text

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


SELECT ARCHIVE_ID
,      PERIOD_NUMBER
,      PERIOD_NAME
,      INVOICES_CNT
,      CREDIT_MEMOS_CNT
,      DEBIT_MEMOS_CNT
,      CHARGEBACKS_CNT
,      DEPOSITS_CNT
,      ADJUSTMENTS_CNT
,      CASH_RECEIPTS_CNT
,      INVOICES_NO_REC_CNT
,      CREDIT_MEMOS_NO_REC_CNT
,      DEBIT_MEMOS_NO_REC_CNT
,      CHARGEBACKS_NO_REC_CNT
,      DEPOSITS_NO_REC_CNT
,      GUARANTEES_CNT
,      MISC_RECEIPTS_CNT
,      INVOICES_TOTAL
,      CREDIT_MEMOS_TOTAL
,      DEBIT_MEMOS_TOTAL
,      CHARGEBACKS_TOTAL
,      DEPOSITS_TOTAL
,      ADJUSTMENTS_TOTAL
,      CASH_RECEIPTS_TOTAL
,      DISCOUNTS_TOTAL
,      EXCHANGE_GAIN_LOSS_TOTAL
,      INVOICES_NO_REC_TOTAL
,      CREDIT_MEMOS_NO_REC_TOTAL
,      DEBIT_MEMOS_NO_REC_TOTAL
,      CHARGEBACKS_NO_REC_TOTAL
,      DEPOSITS_NO_REC_TOTAL
,      GUARANTEES_TOTAL
,      MISC_RECEIPTS_TOTAL
FROM AR.AR_ARCHIVE_CONTROL_DETAIL#;

Dependencies

[top of page]

AR.AR_ARCHIVE_CONTROL_DETAIL# references the following:

AR: AR_ARCHIVE_CONTROL_DETAIL

AR.AR_ARCHIVE_CONTROL_DETAIL# is referenced by following:

APPS: AR_ARCHIVE_CONTROL_DETAIL