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


VIEW: APPS.CSI_IAH_DETAILS_V

Object Details
Object Name: CSI_IAH_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_IAH_DETAILS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE_ASSET_HISTORY_ID NUMBER
Yes
INSTANCE_ASSET_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
INSTANCE_ID NUMBER
Yes
OLD_INSTANCE_ID NUMBER

NEW_INSTANCE_ID NUMBER

OLD_FA_ASSET_ID NUMBER

NEW_FA_ASSET_ID NUMBER

OLD_ASSET_QUANTITY NUMBER

NEW_ASSET_QUANTITY NUMBER

OLD_FA_BOOK_TYPE_CODE VARCHAR2 (15)
NEW_FA_BOOK_TYPE_CODE VARCHAR2 (15)
OLD_FA_LOCATION_ID NUMBER

NEW_FA_LOCATION_ID NUMBER

OLD_UPDATE_STATUS VARCHAR2 (30)
NEW_UPDATE_STATUS VARCHAR2 (30)
FULL_DUMP_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER
Yes
OLD_ACTIVE_START_DATE DATE

NEW_ACTIVE_START_DATE DATE

OLD_ACTIVE_END_DATE DATE

NEW_ACTIVE_END_DATE DATE

OLD_ASSET_NUMBER VARCHAR2 (15)
OLD_TAG_NUMBER VARCHAR2 (15)
OLD_SERIAL_NUMBER VARCHAR2 (35)
OLD_MAJOR_CATEGORY VARCHAR2 (30)
OLD_SUB_CATEGORY VARCHAR2 (30)
NEW_ASSET_NUMBER VARCHAR2 (15)
NEW_TAG_NUMBER VARCHAR2 (15)
NEW_SERIAL_NUMBER VARCHAR2 (35)
NEW_MAJOR_CATEGORY VARCHAR2 (30)
NEW_SUB_CATEGORY VARCHAR2 (30)
Query Text

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


SELECT INSTANCE_ASSET_HISTORY_ID
,      INSTANCE_ASSET_ID
,      TRANSACTION_ID
,      INSTANCE_ID
,      OLD_INSTANCE_ID
,      NEW_INSTANCE_ID
,      OLD_FA_ASSET_ID
,      NEW_FA_ASSET_ID
,      OLD_ASSET_QUANTITY
,      NEW_ASSET_QUANTITY
,      OLD_FA_BOOK_TYPE_CODE
,      NEW_FA_BOOK_TYPE_CODE
,      OLD_FA_LOCATION_ID
,      NEW_FA_LOCATION_ID
,      OLD_UPDATE_STATUS
,      NEW_UPDATE_STATUS
,      FULL_DUMP_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OLD_ACTIVE_START_DATE
,      NEW_ACTIVE_START_DATE
,      OLD_ACTIVE_END_DATE
,      NEW_ACTIVE_END_DATE
,      OLD_ASSET_NUMBER
,      OLD_TAG_NUMBER
,      OLD_SERIAL_NUMBER
,      OLD_MAJOR_CATEGORY
,      OLD_SUB_CATEGORY
,      NEW_ASSET_NUMBER
,      NEW_TAG_NUMBER
,      NEW_SERIAL_NUMBER
,      NEW_MAJOR_CATEGORY
,      NEW_SUB_CATEGORY
FROM APPS.CSI_IAH_DETAILS_V;

Dependencies

[top of page]

APPS.CSI_IAH_DETAILS_V references the following:

SchemaAPPS
SynonymCSI_I_ASSETS
SynonymCSI_I_ASSETS_H
SynonymFA_ADDITIONS
SynonymFA_CATEGORIES_B

APPS.CSI_IAH_DETAILS_V is not referenced by any database object