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


TABLE: GHG.GHG_ASSETS

Object Details
Object Name: GHG_ASSETS
Object Type: TABLE
Owner: GHG
FND Design Data: TableGHG.GHG_ASSETS
Subobject Name:
Status: VALID


This table stores asset information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GHG_ASSETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGHG_ASSET_ID
GHG_ASSETS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
GHG_ASSETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_NUMBER
ColumnBOOK_TYPE_CODE
GHG_ASSETS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_ID
GHG_ASSETS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_TYPE_LOOKUP_CODE
Columns
Name Datatype Length Mandatory Comments
GHG_ASSET_ID NUMBER (15) Yes GHG Asset Identifier
ASSET_ID NUMBER (15)
Asset Identifier
ASSET_TYPE_LOOKUP_CODE VARCHAR2 (30) Yes Asset Type Lookup Code
BOOK_TYPE_CODE VARCHAR2 (15)
Book Type Code
ASSET_NUMBER VARCHAR2 (15) Yes Asset Number
TAG_NUMBER VARCHAR2 (15)
Tag Number
SERIAL_NUMBER VARCHAR2 (35)
Serial Number
TRANSPORT_TYPE_LOOKUP_CODE VARCHAR2 (30) Yes Transport Type Lookup Code
VENDOR_ID NUMBER (15)
Vendor Identifier
VENDOR_SITE_ID NUMBER (15)
Vendor Site Identifier
START_DATE DATE
Yes Start Date
END_DATE DATE

End Date
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
GHG_ORGANIZATION_ID NUMBER

GHG Organization Identifier
DESCRIPTION#1 VARCHAR2 (240)
Description for Editioning View
Query Text

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


SELECT GHG_ASSET_ID
,      ASSET_ID
,      ASSET_TYPE_LOOKUP_CODE
,      BOOK_TYPE_CODE
,      ASSET_NUMBER
,      TAG_NUMBER
,      SERIAL_NUMBER
,      TRANSPORT_TYPE_LOOKUP_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GHG_ORGANIZATION_ID
,      DESCRIPTION#1
FROM GHG.GHG_ASSETS;

Dependencies

[top of page]

GHG.GHG_ASSETS does not reference any database object

GHG.GHG_ASSETS is referenced by following:

SchemaGHG
ViewGHG_ASSETS#