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


TABLE: IGI.IGI_INV_DIST_GT

Object Details
Object Name: IGI_INV_DIST_GT
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_INV_DIST_GT
Subobject Name:
Status: VALID

Temporary Table Details

IGI.IGI_INV_DIST_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$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
DISTRIBUTION_LINE_NUMBER NUMBER (15) Yes
INVOICE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ORG_ID NUMBER

IGI_MPP_ID NUMBER (15)
IGI_MPP_LINE_NUM NUMBER (15)
IGI_MPP_STATUS VARCHAR2 (1)
IGI_MPP_ACCT_RULE NUMBER (15)
IGI_MPP_FIRST_GL_DATE DATE

IGI_MPP_DURATION NUMBER (15)
IGI_MPP_EXP_CCID NUMBER (15)
IGI_SAP_FLAG VARCHAR2 (1)
INVOICE_LINE_NUMBER NUMBER

Query Text

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


SELECT DISTRIBUTION_LINE_NUMBER
,      INVOICE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      IGI_MPP_ID
,      IGI_MPP_LINE_NUM
,      IGI_MPP_STATUS
,      IGI_MPP_ACCT_RULE
,      IGI_MPP_FIRST_GL_DATE
,      IGI_MPP_DURATION
,      IGI_MPP_EXP_CCID
,      IGI_SAP_FLAG
,      INVOICE_LINE_NUMBER
FROM IGI.IGI_INV_DIST_GT;

Dependencies

[top of page]

IGI.IGI_INV_DIST_GT does not reference any database object

IGI.IGI_INV_DIST_GT is referenced by following:

SchemaAPPS
SynonymIGI_INV_DIST_GT