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

VIEW: IGI.IGI_IAC_CATEGORY_BOOKS#

Object Details
Object Name: IGI_IAC_CATEGORY_BOOKS#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BOOK_TYPE_CODE VARCHAR2 (15) Yes
CATEGORY_ID NUMBER (15) Yes
CAL_PRICE_INDEX_LINK_ID NUMBER (15)
BACKLOG_DEPRN_RSV_CCID NUMBER (15) Yes
GENERAL_FUND_CCID NUMBER (15) Yes
OPERATING_EXPENSE_CCID NUMBER (15)
PRICE_INDEX_ID NUMBER (15)
ALLOW_INDEXED_REVAL_FLAG VARCHAR2 (1)
ALLOW_PROF_REVAL_FLAG VARCHAR2 (1)
REVAL_FULLY_RSVD_FLAG VARCHAR2 (1)
MAX_FULLY_RSVD_REVELS NUMBER (3)
IMP_DATE DATE

IMP_RUN_NUMBER NUMBER (4)
IMP_PERIOD_COUNTER NUMBER (15)
REVAL_RSV_CCID NUMBER (15)
REVAL_RSV_RET_CCID NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
Query Text

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


SELECT BOOK_TYPE_CODE
,      CATEGORY_ID
,      CAL_PRICE_INDEX_LINK_ID
,      BACKLOG_DEPRN_RSV_CCID
,      GENERAL_FUND_CCID
,      OPERATING_EXPENSE_CCID
,      PRICE_INDEX_ID
,      ALLOW_INDEXED_REVAL_FLAG
,      ALLOW_PROF_REVAL_FLAG
,      REVAL_FULLY_RSVD_FLAG
,      MAX_FULLY_RSVD_REVELS
,      IMP_DATE
,      IMP_RUN_NUMBER
,      IMP_PERIOD_COUNTER
,      REVAL_RSV_CCID
,      REVAL_RSV_RET_CCID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM IGI.IGI_IAC_CATEGORY_BOOKS#;

Dependencies

[top of page]

IGI.IGI_IAC_CATEGORY_BOOKS# references the following:

SchemaIGI
TableIGI_IAC_CATEGORY_BOOKS
IGI.IGI_IAC_CATEGORY_BOOKS# is referenced by following:

SchemaAPPS
SynonymIGI_IAC_CATEGORY_BOOKS