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

TABLE: IGC.IGC_CC_PROCESS_EXCEPTIONS_ALL

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


IGC_CC_PROCESS_EXCEPTIONS stores temporary data pertaining to errors that were generated during the contract commitment's year end processing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_PROCESS_EXCEPTIONS_A_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnSET_OF_BOOKS_ID
ColumnORG_ID
ColumnCC_HEADER_ID
ColumnCC_DET_PF_LINE_ID
ColumnCC_ACCT_LINE_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_TYPE VARCHAR2 (1)
Category of process such as year end or revaluation
PROCESS_PHASE VARCHAR2 (1)
Validation phase
CC_HEADER_ID NUMBER

Contract commitment defining column
CC_ACCT_LINE_ID NUMBER

Account line defining column
CC_DET_PF_LINE_ID NUMBER

Detail payment forecast line defining column
EXCEPTION_REASON VARCHAR2 (1260)
Reason the process failed
ORG_ID NUMBER (15)
Organization identifier
SET_OF_BOOKS_ID NUMBER (15)
Accounting books defining column
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
Query Text

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


SELECT PROCESS_TYPE
,      PROCESS_PHASE
,      CC_HEADER_ID
,      CC_ACCT_LINE_ID
,      CC_DET_PF_LINE_ID
,      EXCEPTION_REASON
,      ORG_ID
,      SET_OF_BOOKS_ID
,      REQUEST_ID
FROM IGC.IGC_CC_PROCESS_EXCEPTIONS_ALL;

Dependencies

[top of page]

IGC.IGC_CC_PROCESS_EXCEPTIONS_ALL does not reference any database object

IGC.IGC_CC_PROCESS_EXCEPTIONS_ALL is referenced by following:

SchemaAPPS
SynonymIGC_CC_PROCESS_EXCEPTIONS
SynonymIGC_CC_PROCESS_EXCEPTIONS_ALL