[Home] [Help]
[Dependency Information]
Object Name: | IPA_ASSET_NAMING_CONVENTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IPA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Table to store Asset Naming Convention for CRL Asset mechanization process.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IPA_ASSET_NAME_CONVENT_ALL_U1 | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSET_NAME_ID | NUMBER | (15) | Yes | Id of the AssetNaming Convention record |
ASSET_NAME | VARCHAR2 | (25) | Yes | Stores Entity Name from which the value of Asset Name would be derived. |
ASSET_DESCRIPTION1 | VARCHAR2 | (25) | Yes | Stores Entity Name from which value of the First Segment of Asset Description would be drived. |
ASSET_DESCRIPTION2 | VARCHAR2 | (25) | Stores Entity Name from which value of the Second Segment of Asset Description would be drived. | |
ASSET_DESCRIPTION3 | VARCHAR2 | (25) | Stores Entity Name from which value of the Third Segment of Asset Description would be drived. | |
ASSET_DESC_SEPARATOR | VARCHAR2 | (1) | Yes | Separator to delimit the 3 segments of Asset Description |
ASSET_LOCATION | VARCHAR2 | (25) | Yes | Stores Entity Name from which value of the Location would be drived. |
ASSET_CATEGORY | VARCHAR2 | (25) | Yes | Stores Entity Name from which value of the Category would be drived. |
ORG_ID | NUMBER | Operating Unit Id of the Multi Organization Installation | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_NAME_ID
, ASSET_NAME
, ASSET_DESCRIPTION1
, ASSET_DESCRIPTION2
, ASSET_DESCRIPTION3
, ASSET_DESC_SEPARATOR
, ASSET_LOCATION
, ASSET_CATEGORY
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IPA.IPA_ASSET_NAMING_CONVENTS_ALL;
IPA.IPA_ASSET_NAMING_CONVENTS_ALL does not reference any database object
IPA.IPA_ASSET_NAMING_CONVENTS_ALL is referenced by following:
|
|
|