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

TABLE: AR.JG_ZZ_INT_INV_LINES_ALL

Object Details
Object Name: JG_ZZ_INT_INV_LINES_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableJG.JG_ZZ_INT_INV_LINES_ALL
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JG_ZZ_INT_INV_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_INVOICE_ID
ColumnINTEREST_INVOICE_LINE_ID
ColumnORG_ID
JG_ZZ_INT_INV_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_INVOICE_LINE_ID NUMBER (15) Yes
INTEREST_INVOICE_ID NUMBER (15) Yes
PAYMENT_SCHEDULE_ID NUMBER (15)
TYPE VARCHAR2 (30) Yes
DAILY_INTEREST_CHARGE NUMBER

OUTSTANDING_AMOUNT NUMBER

DAYS_OVERDUE_LATE NUMBER

DAYS_OF_INTEREST NUMBER

INTEREST_CHARGED NUMBER

PAYMENT_DATE DATE

RECEIVABLE_APPLICATION_ID NUMBER

LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ORG_ID NUMBER (15)
INTEREST_RATE NUMBER

Query Text

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


SELECT INTEREST_INVOICE_LINE_ID
,      INTEREST_INVOICE_ID
,      PAYMENT_SCHEDULE_ID
,      TYPE
,      DAILY_INTEREST_CHARGE
,      OUTSTANDING_AMOUNT
,      DAYS_OVERDUE_LATE
,      DAYS_OF_INTEREST
,      INTEREST_CHARGED
,      PAYMENT_DATE
,      RECEIVABLE_APPLICATION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ORG_ID
,      INTEREST_RATE
FROM AR.JG_ZZ_INT_INV_LINES_ALL;

Dependencies

[top of page]

AR.JG_ZZ_INT_INV_LINES_ALL does not reference any database object

AR.JG_ZZ_INT_INV_LINES_ALL is referenced by following:

SchemaAPPS
SynonymJG_ZZ_INT_INV_LINES_ALL