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

VIEW: AR.AR_STATEMENTS_HISTORY_ALL#

Object Details
Object Name: AR_STATEMENTS_HISTORY_ALL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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)
FINANCE_CHARGES NUMBER
Yes
TOTAL_AMOUNT_DUE NUMBER
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)
IS_IT_A_REPRINT VARCHAR2 (1)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
ORG_ID NUMBER (15)
STATEMENT_CYCLE_ID NUMBER (15) Yes
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
,      FINANCE_CHARGES
,      TOTAL_AMOUNT_DUE
,      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
,      IS_IT_A_REPRINT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ORG_ID
,      STATEMENT_CYCLE_ID
FROM AR.AR_STATEMENTS_HISTORY_ALL#;

Dependencies

[top of page]

AR.AR_STATEMENTS_HISTORY_ALL# references the following:

SchemaAR
TableAR_STATEMENTS_HISTORY_ALL
AR.AR_STATEMENTS_HISTORY_ALL# is referenced by following:

SchemaAPPS
SynonymAR_STATEMENTS_HISTORY
SynonymAR_STATEMENTS_HISTORY_ALL