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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
LINE_CLUSTER_ID	NUMBER	(15)	Yes
SEND_TO_ADDRESS_ID	NUMBER	(15)	Yes
CUSTOMER_ID	NUMBER	(15)	Yes
REMIT_TO_ADDRESS_ID	NUMBER	(15)	Yes
STATEMENT_DATE	DATE		Yes
CURRENCY_CODE	VARCHAR2	(15)
BUCKET1_HEADING	VARCHAR2	(30)
BUCKET2_HEADING	VARCHAR2	(30)
BUCKET3_HEADING	VARCHAR2	(30)
BUCKET4_HEADING	VARCHAR2	(30)
BUCKET5_HEADING	VARCHAR2	(30)
BUCKET1	NUMBER		Yes
BUCKET2	NUMBER		Yes
BUCKET3	NUMBER		Yes
BUCKET4	NUMBER		Yes
BUCKET5	NUMBER		Yes
FINANCE_CHARGES	NUMBER		Yes
TOTAL_AMOUNT_DUE	NUMBER		Yes
ERROR_AMOUNT_DIFFERENT	VARCHAR2	(1)	Yes
ERROR_NO_SEND_TO	VARCHAR2	(1)	Yes
ERROR_NO_REMIT_TO	VARCHAR2	(1)	Yes
ERROR_NO_LINES	VARCHAR2	(1)	Yes
MESSAGE1	NUMBER
MESSAGE2	NUMBER
MESSAGE3	NUMBER
MESSAGE4	NUMBER
MESSAGE5	NUMBER
MESSAGE6	NUMBER
MESSAGE7	NUMBER
MESSAGE8	NUMBER
MESSAGE1_LINE_COUNT	NUMBER
MESSAGE2_LINE_COUNT	NUMBER
MESSAGE3_LINE_COUNT	NUMBER
MESSAGE4_LINE_COUNT	NUMBER
MESSAGE5_LINE_COUNT	NUMBER
MESSAGE6_LINE_COUNT	NUMBER
MESSAGE7_LINE_COUNT	NUMBER
MESSAGE8_LINE_COUNT	NUMBER
REQUEST_ID	NUMBER	(15)	Yes
SITE_USE_ID	NUMBER	(15)	Yes
STATEMENT_TYPE	VARCHAR2	(30)	Yes
BILL_TO_LOCATION	VARCHAR2	(40)
CREDIT_BALANCE_STATEMENTS	VARCHAR2	(1)
CUST_CUSTOMER_PROFILE_ID	NUMBER	(15)
MIN_STATEMENT_AMOUNT	NUMBER
MONTHLY_INTEREST_RATE	NUMBER
SITE_CUSTOMER_PROFILE_ID	NUMBER	(15)

Query Text

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


SELECT LINE_CLUSTER_ID
,      SEND_TO_ADDRESS_ID
,      CUSTOMER_ID
,      REMIT_TO_ADDRESS_ID
,      STATEMENT_DATE
,      CURRENCY_CODE
,      BUCKET1_HEADING
,      BUCKET2_HEADING
,      BUCKET3_HEADING
,      BUCKET4_HEADING
,      BUCKET5_HEADING
,      BUCKET1
,      BUCKET2
,      BUCKET3
,      BUCKET4
,      BUCKET5
,      FINANCE_CHARGES
,      TOTAL_AMOUNT_DUE
,      ERROR_AMOUNT_DIFFERENT
,      ERROR_NO_SEND_TO
,      ERROR_NO_REMIT_TO
,      ERROR_NO_LINES
,      MESSAGE1
,      MESSAGE2
,      MESSAGE3
,      MESSAGE4
,      MESSAGE5
,      MESSAGE6
,      MESSAGE7
,      MESSAGE8
,      MESSAGE1_LINE_COUNT
,      MESSAGE2_LINE_COUNT
,      MESSAGE3_LINE_COUNT
,      MESSAGE4_LINE_COUNT
,      MESSAGE5_LINE_COUNT
,      MESSAGE6_LINE_COUNT
,      MESSAGE7_LINE_COUNT
,      MESSAGE8_LINE_COUNT
,      REQUEST_ID
,      SITE_USE_ID
,      STATEMENT_TYPE
,      BILL_TO_LOCATION
,      CREDIT_BALANCE_STATEMENTS
,      CUST_CUSTOMER_PROFILE_ID
,      MIN_STATEMENT_AMOUNT
,      MONTHLY_INTEREST_RATE
,      SITE_CUSTOMER_PROFILE_ID
FROM AR.AR_STATEMENT_HEADERS#;

Dependencies

[top of page]

AR.AR_STATEMENT_HEADERS# references the following:

AR: AR_STATEMENT_HEADERS

AR.AR_STATEMENT_HEADERS# is referenced by following:

APPS: AR_STATEMENT_HEADERS