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


TABLE: IGI.IGI_CEC_ENCUMBRANCE_TYPES_ALL

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


IGI_CEC_ENCUMBRANCE_TYPES_ALL stores the status and type of encumbrance for contract encumbrancing.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books unique identifier
IGI_CEC_CE_TYPE_ID NUMBER (15)
Commitment encumbrance type
IGI_CEC_CE_FLAG VARCHAR2 (1)
Commitment encumbrance flag. Values are Y or N.
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT SET_OF_BOOKS_ID
,      IGI_CEC_CE_TYPE_ID
,      IGI_CEC_CE_FLAG
,      ORG_ID
FROM IGI.IGI_CEC_ENCUMBRANCE_TYPES_ALL;

Dependencies

[top of page]

IGI.IGI_CEC_ENCUMBRANCE_TYPES_ALL does not reference any database object

IGI.IGI_CEC_ENCUMBRANCE_TYPES_ALL is referenced by following:

SchemaAPPS
SynonymIGI_CEC_ENCUMBRANCE_TYPES_ALL