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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
CUSTOMER_ID	NUMBER
CUSTOMER_NUMBER	VARCHAR2	(200)
SHORT_CUSTOMER_NAME	VARCHAR2	(240)
SORT_FIELD1	VARCHAR2	(500)
SORT_FIELD2	VARCHAR2	(500)
INV_TID_INV	VARCHAR2	(30)
CONTACT_SITE_ID	NUMBER
CUSTOMER_STATE	VARCHAR2	(60)
CUSTOMER_CITY	VARCHAR2	(60)
CUST_ACCT_SITE_ID	NUMBER
PAYMENT_SCHEDULE_ID	NUMBER
CLASS	VARCHAR2	(20)
DUE_DATE	DATE
AMT_DUE_REMAINING	NUMBER
TRX_NUMBER	VARCHAR2	(30)
DAYS_PAST_DUE	NUMBER
AMOUNT_ADJUSTED	NUMBER
AMOUNT_APPLIED	NUMBER
AMOUNT_CREDITED	NUMBER
GL_DATE	DATE
DATA_CONVERTED_FLAG	VARCHAR2	(1)
EXCHANGE_RATE	NUMBER
BUCKET_0	NUMBER
BUCKET_1	NUMBER
BUCKET_2	NUMBER
BUCKET_3	NUMBER
BUCKET_4	NUMBER
BUCKET_5	NUMBER
BUCKET_6	NUMBER
BAL_SEGMENT_VALUE	VARCHAR2	(25)
INVOICE_TYPE	VARCHAR2	(200)
CONS_BILLING_NUMBER	VARCHAR2	(200)
CONTACT_NAME	VARCHAR2	(360)
CONTACT_PHONE	VARCHAR2	(360)
CATEGORY	VARCHAR2	(30)
PARENT_REQUEST_ID	NUMBER
WORKER_ID	NUMBER

Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_NUMBER
,      SHORT_CUSTOMER_NAME
,      SORT_FIELD1
,      SORT_FIELD2
,      INV_TID_INV
,      CONTACT_SITE_ID
,      CUSTOMER_STATE
,      CUSTOMER_CITY
,      CUST_ACCT_SITE_ID
,      PAYMENT_SCHEDULE_ID
,      CLASS
,      DUE_DATE
,      AMT_DUE_REMAINING
,      TRX_NUMBER
,      DAYS_PAST_DUE
,      AMOUNT_ADJUSTED
,      AMOUNT_APPLIED
,      AMOUNT_CREDITED
,      GL_DATE
,      DATA_CONVERTED_FLAG
,      EXCHANGE_RATE
,      BUCKET_0
,      BUCKET_1
,      BUCKET_2
,      BUCKET_3
,      BUCKET_4
,      BUCKET_5
,      BUCKET_6
,      BAL_SEGMENT_VALUE
,      INVOICE_TYPE
,      CONS_BILLING_NUMBER
,      CONTACT_NAME
,      CONTACT_PHONE
,      CATEGORY
,      PARENT_REQUEST_ID
,      WORKER_ID
FROM AR.AR_AGING_EXTRACT#;

Dependencies

[top of page]

AR.AR_AGING_EXTRACT# references the following:

AR: AR_AGING_EXTRACT

AR.AR_AGING_EXTRACT# is referenced by following:

APPS: AR_AGING_EXTRACT