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

TABLE: IGC.IGC_CBC_PO_PROCESS_GT

Object Details
Object Name: IGC_CBC_PO_PROCESS_GT
Object Type: TABLE
Owner: IGC
Subobject Name:
Status: VALID

Temporary Table Details

IGC.IGC_CBC_PO_PROCESS_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
IGC_CBC_PO_PROCESS_GT_N1 NORMAL NONUNIQUE Tablespace ColumnPO_HEADER_ID
IGC_CBC_PO_PROCESS_GT_N2 NORMAL NONUNIQUE Tablespace ColumnPO_RELEASE_ID
IGC_CBC_PO_PROCESS_GT_N3 NORMAL NONUNIQUE Tablespace ColumnREQ_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_TYPE VARCHAR2 (3)
PO_RELEASE_ID NUMBER

PO_HEADER_ID NUMBER

REQ_HEADER_ID NUMBER

LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

DISTRIBUTION_ID NUMBER

ACCRUE_ON_RECEIPT VARCHAR2 (1)
QUANTITY_ORDERED NUMBER

QUANTITY_BILLED NUMBER

ENCUMBERED_FLAG VARCHAR2 (1)
GL_ENCUMBERED_DATE DATE

GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (30)
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
BLANKET_PO_HEADER_ID NUMBER

Query Text

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


SELECT DOCUMENT_TYPE
,      PO_RELEASE_ID
,      PO_HEADER_ID
,      REQ_HEADER_ID
,      LINE_ID
,      LINE_LOCATION_ID
,      DISTRIBUTION_ID
,      ACCRUE_ON_RECEIPT
,      QUANTITY_ORDERED
,      QUANTITY_BILLED
,      ENCUMBERED_FLAG
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      PREVENT_ENCUMBRANCE_FLAG
,      BLANKET_PO_HEADER_ID
FROM IGC.IGC_CBC_PO_PROCESS_GT;

Dependencies

[top of page]

IGC.IGC_CBC_PO_PROCESS_GT does not reference any database object

IGC.IGC_CBC_PO_PROCESS_GT is referenced by following:

SchemaAPPS
SynonymIGC_CBC_PO_PROCESS_GT