eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGC.IGC_CC_HISTORY_SUMMARY_GT

Object Details

Object Name:	IGC_CC_HISTORY_SUMMARY_GT
Object Type:	TABLE
Owner:	IGC
Subobject Name:
Status:	VALID

Temporary Table Details

IGC.IGC_CC_HISTORY_SUMMARY_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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CC_HISTORY_SUMMARY_GT_N1	NORMAL	NONUNIQUE		CC_HEADER_ID
IGC_CC_HISTORY_SUMMARY_GT_N2	NORMAL	NONUNIQUE		VERSION_NUM

Columns

Name	Datatype	Length
CC_HEADER_ID	NUMBER
CC_NUM	VARCHAR2	(20)
CC_TYPE	VARCHAR2	(1)
CC_TYPE_DESC	VARCHAR2	(30)
ORG_ID	NUMBER	(15)
VERSION_NUM	NUMBER
CC_STATE	VARCHAR2	(2)
CC_STATE_DESC	VARCHAR2	(30)
CC_APPRVL_STATUS	VARCHAR2	(2)
APPROVAL_STATUS_DESC	VARCHAR2	(30)
CC_CTRL_STATUS	VARCHAR2	(1)
CONTROL_STATUS_DESC	VARCHAR2	(30)
CC_ENCMBRNC_STATUS	VARCHAR2	(1)
ENC_STATUS_DESC	VARCHAR2	(30)
PARENT_HEADER_ID	NUMBER
PARENT_CC_NUM	VARCHAR2	(20)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_ID	NUMBER
BILL_TO_LOCATION	VARCHAR2	(60)
LOCATION_ID	NUMBER
OWNER_NAME	VARCHAR2	(100)
CC_OWNER_USER_ID	NUMBER	(15)
PREPARER_NAME	VARCHAR2	(100)
CC_PREPARER_USER_ID	NUMBER	(15)
CURRENCY_CODE	VARCHAR2	(15)
CONVERSION_TYPE	VARCHAR2	(30)
CONVERSION_DATE	DATE
CONVERSION_RATE	NUMBER

Query Text

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


SELECT CC_HEADER_ID
,      CC_NUM
,      CC_TYPE
,      CC_TYPE_DESC
,      ORG_ID
,      VERSION_NUM
,      CC_STATE
,      CC_STATE_DESC
,      CC_APPRVL_STATUS
,      APPROVAL_STATUS_DESC
,      CC_CTRL_STATUS
,      CONTROL_STATUS_DESC
,      CC_ENCMBRNC_STATUS
,      ENC_STATUS_DESC
,      PARENT_HEADER_ID
,      PARENT_CC_NUM
,      VENDOR_NAME
,      VENDOR_ID
,      BILL_TO_LOCATION
,      LOCATION_ID
,      OWNER_NAME
,      CC_OWNER_USER_ID
,      PREPARER_NAME
,      CC_PREPARER_USER_ID
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
FROM IGC.IGC_CC_HISTORY_SUMMARY_GT;

Dependencies

[top of page]

IGC.IGC_CC_HISTORY_SUMMARY_GT does not reference any database object

IGC.IGC_CC_HISTORY_SUMMARY_GT is referenced by following:

APPS: IGC_CC_HISTORY_SUMMARY_GT