[Home] [Help] [Dependency Information]
Object Name: | IPA_ASSET_NAMING_CONVENTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IPA |
FND Design Data: | IPA.IPA_ASSET_NAMING_CONVENTS_ALL |
Subobject Name: | |
Status: | VALID |
Table to store Asset Naming Convention for CRL Asset mechanization process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IPA_ASSET_NAME_CONVENT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORG_ID |
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 Can have values ANT - Asset Name would be derived from Task Name ANP - Asset Name would be derived from Project Name ANGE1 - Asset Name would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ANGE2 - Asset Name would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ANGE3 - Asset Name would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table |
ASSET_DESCRIPTION1 | VARCHAR2 | (25) | Yes | Stores Entity Name from which value of the First Segment of Asset Description would be drived Can have values ADT - Asset Description1 would be derived from Task Name ADP - Asset Description1 would be derived from Project Name ADGE1 - Asset Description1 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description1 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description1 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table |
ASSET_DESCRIPTION2 | VARCHAR2 | (25) | Stores Entity Name from which value of the Second Segment of Asset Description would be drived Can have values ADT - Asset Description2 would be derived from Task Name ADP - Asset Description2 would be derived from Project Name ADGE1 - Asset Description2 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description2 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description2 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description2 would have a null value | |
ASSET_DESCRIPTION3 | VARCHAR2 | (25) | Stores Entity Name from which value of the Third Segment of Asset Description would be drived Can have values ADT - Asset Description3 would be derived from Task Name ADP - Asset Description3 would be derived from Project Name ADGE1 - Asset Description3 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description3 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description3 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description3 would have a null value | |
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 Can have values ALGE1 - Asset Location would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ALGE2 - Asset Location would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ALGE3 - Asset Location would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table |
ASSET_CATEGORY | VARCHAR2 | (25) | Yes | Stores Entity Name from which value of the Category would be drived Can have values ACT - Asset Category would be derived from Task Name ACDF - Asset Category would be derived from Descriptive Flexfield Attribute 10 on Task ACGE1 - Asset Category would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ACGE2 - Asset Category would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ACGE3 - Asset Category would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description3 would have a null value |
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:
|
|
|