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

TABLE: AP.AP_ALLOCATION_RULE_LINES_GT

Object Details
Object Name: AP_ALLOCATION_RULE_LINES_GT
Object Type: TABLE
Owner: AP
Subobject Name:
Status: VALID

Temporary Table Details

AP.AP_ALLOCATION_RULE_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
AP_ALLOCATION_RULE_LINES_GT_U1 NORMAL UNIQUE Tablespace ColumnINVOICE_ID
ColumnCHRG_INVOICE_LINE_NUMBER
ColumnTO_INVOICE_LINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes
CHRG_INVOICE_LINE_NUMBER NUMBER

TO_INVOICE_LINE_NUMBER NUMBER

PERCENTAGE NUMBER

AMOUNT NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
Query Text

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


SELECT INVOICE_ID
,      CHRG_INVOICE_LINE_NUMBER
,      TO_INVOICE_LINE_NUMBER
,      PERCENTAGE
,      AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM AP.AP_ALLOCATION_RULE_LINES_GT;

Dependencies

[top of page]

AP.AP_ALLOCATION_RULE_LINES_GT does not reference any database object

AP.AP_ALLOCATION_RULE_LINES_GT is referenced by following:

SchemaAPPS
SynonymAP_ALLOCATION_RULE_LINES_GT