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

VIEW: IGI.IGI_IMP_IAC_EXCEP_REP_ITF#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER

SOB_BOOK VARCHAR2 (30)
ORGANISATION_NAME VARCHAR2 (30)
CORP_BOOK VARCHAR2 (15)
TAX_BOOK VARCHAR2 (15)
PERIOD VARCHAR2 (30)
FISCAL_YEAR_NAME VARCHAR2 (30)
WARNING_MESSAGE VARCHAR2 (100)
WARNING_MESSAGE_CODE VARCHAR2 (1)
ASSET_NUMBER VARCHAR2 (15)
ASSET_DESCRIPTION VARCHAR2 (80)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
DPIS_CORP DATE

DPIS_TAX DATE

ASSET_LIFE_CORP NUMBER (15)
ASSET_LIFE_TAX NUMBER (15)
CONCAT_CATEGORY VARCHAR2 (600)
HIST_COST_CORP NUMBER

HIST_COST_TAX NUMBER

SALVAGE_VALUE_CORP NUMBER

SALVAGE_VALUE_TAX NUMBER

CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER (15)
LSAT_UPDATE_DATE DATE

Query Text

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


SELECT REQUEST_ID
,      SOB_BOOK
,      ORGANISATION_NAME
,      CORP_BOOK
,      TAX_BOOK
,      PERIOD
,      FISCAL_YEAR_NAME
,      WARNING_MESSAGE
,      WARNING_MESSAGE_CODE
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      FUNCTIONAL_CURRENCY_CODE
,      DPIS_CORP
,      DPIS_TAX
,      ASSET_LIFE_CORP
,      ASSET_LIFE_TAX
,      CONCAT_CATEGORY
,      HIST_COST_CORP
,      HIST_COST_TAX
,      SALVAGE_VALUE_CORP
,      SALVAGE_VALUE_TAX
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LSAT_UPDATE_DATE
FROM IGI.IGI_IMP_IAC_EXCEP_REP_ITF#;

Dependencies

[top of page]

IGI.IGI_IMP_IAC_EXCEP_REP_ITF# references the following:

SchemaIGI
TableIGI_IMP_IAC_EXCEP_REP_ITF
IGI.IGI_IMP_IAC_EXCEP_REP_ITF# is referenced by following:

SchemaAPPS
SynonymIGI_IMP_IAC_EXCEP_REP_ITF