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

VIEW: AR.AR_STATEMENT_LINE_CLUSTERS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_CLUSTER_ID NUMBER (15) Yes
CUSTOMER_TRX_SEQUENCE NUMBER (15) Yes
PAYMENT_SCHEDULE_SEQUENCE NUMBER (15) Yes
TRX_ORDER_SEQUENCE NUMBER (15) Yes
GENERAL_SEQUENCE NUMBER (15) Yes
INVOICE_NUMBER VARCHAR2 (30)
TRX_DATE DATE

TRANSACTION VARCHAR2 (100)
DUE_DATE DATE

REFERENCE VARCHAR2 (100)
BILL_TO_LOCATION VARCHAR2 (100)
TRX_AMOUNT NUMBER

AMOUNT_DUE NUMBER

ADJUSTMENT_ID NUMBER (15)
CUSTOMER_ID NUMBER (15) Yes
RECEIVABLE_APPLICATION_ID NUMBER (15)
REQUEST_ID NUMBER (15) Yes
SITE_USE_ID NUMBER (15)
BILL_TO_CITY VARCHAR2 (60)
ORIG_PAYMENT_AMOUNT NUMBER

TRANSACTION_CODE VARCHAR2 (80)
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
AMOUNT_APPLIED_FROM NUMBER

Query Text

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


SELECT LINE_CLUSTER_ID
,      CUSTOMER_TRX_SEQUENCE
,      PAYMENT_SCHEDULE_SEQUENCE
,      TRX_ORDER_SEQUENCE
,      GENERAL_SEQUENCE
,      INVOICE_NUMBER
,      TRX_DATE
,      TRANSACTION
,      DUE_DATE
,      REFERENCE
,      BILL_TO_LOCATION
,      TRX_AMOUNT
,      AMOUNT_DUE
,      ADJUSTMENT_ID
,      CUSTOMER_ID
,      RECEIVABLE_APPLICATION_ID
,      REQUEST_ID
,      SITE_USE_ID
,      BILL_TO_CITY
,      ORIG_PAYMENT_AMOUNT
,      TRANSACTION_CODE
,      RECEIPT_CURRENCY_CODE
,      AMOUNT_APPLIED_FROM
FROM AR.AR_STATEMENT_LINE_CLUSTERS#;

Dependencies

[top of page]

AR.AR_STATEMENT_LINE_CLUSTERS# references the following:

SchemaAR
TableAR_STATEMENT_LINE_CLUSTERS
AR.AR_STATEMENT_LINE_CLUSTERS# is referenced by following:

SchemaAPPS
SynonymAR_STATEMENT_LINE_CLUSTERS