[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_EAM_ASSET_NUM_INTERFACE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.MTL_EAM_ASSET_NUM_INTERFACE_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is on top of the base table MTL_EAM_ASSET_NUM_INTERFACE. It shows the details of the assets and rebuilds that users want to import into EAM system.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_GROUP_ID | NUMBER | Interface Group Identifier | ||
| INTERFACE_HEADER_ID | NUMBER | Interface Header Identifier | ||
| BATCH_ID | NUMBER | Batch ID | ||
| BATCH_NAME | VARCHAR2 | (30) | Batch Name | |
| PROCESS_FLAG_CODE | VARCHAR2 | (80) | Process Flag code | |
| PROCESS_FLAG | VARCHAR2 | (1) | Process Flag (S/E/P/R) | |
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
| LAST_UPDATE_DATE | DATE | Standard last update date | ||
| LAST_UPDATED_BY | NUMBER | Standard last update by | ||
| CREATION_DATE | DATE | Standard creation date | ||
| CREATED_BY | NUMBER | Standard creation by | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard update login | ||
| REQUEST_ID | NUMBER | Request ID | ||
| PROGRAM_APPLICATION_ID | NUMBER | Program application id | ||
| PROGRAM_ID | NUMBER | Program ID | ||
| PROGRAM_UPDATE_DATE | DATE | Program update date | ||
| PARENT_INVENTORY_ITEM_ID | NUMBER | Parent inventory item identifier | ||
| PARENT_SERIAL_NUMBER | VARCHAR2 | (30) | Parent serial number | |
| PARENT_INSTANCE_NUMBER | VARCHAR2 | (30) | Parent Instance Number | |
| DESCRIPTIVE_TEXT | VARCHAR2 | (240) | Description text for asset number | |
| CURRENT_ORGANIZATION_ID | NUMBER | Current organization identifier | ||
| WIP_ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | WIP Accounting class code | |
| MAINTAINABLE_FLAG | VARCHAR2 | (1) | Maintainable flag | |
| OWNING_DEPARTMENT_ID | NUMBER | Owning department ID | ||
| NETWORK_ASSET_FLAG | VARCHAR2 | (1) | Route asset flag (Y/N) | |
| FA_ASSET_ID | NUMBER | Fixed Asset ID | ||
| PN_LOCATION_ID | NUMBER | Property Management location ID | ||
| PN_LOCATION_NAME | VARCHAR2 | (30) | Property Management location name | |
| PN_LOCATION_CODE | VARCHAR2 | (90) | Property Management location code | |
| EAM_LOCATION_ID | NUMBER | Area ID | ||
| ASSET_CRITICALITY_CODE | VARCHAR2 | (80) | Asset criticality code | |
| CATEGORY_ID | NUMBER | Category ID | ||
| ERROR_CODE | NUMBER | Error Code | ||
| ERROR_MESSAGE | VARCHAR2 | (240) | Error Message | |
| ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
| EQP_SERIAL_NUMBER | VARCHAR2 | (30) | Equipment serial number | |
| EQUIPMENT_ITEM_ID | NUMBER | Equipment item ID | ||
| PROD_ORGANIZATION_ID | NUMBER | Production organization ID | ||
| FA_ASSET_NUMBER | VARCHAR2 | (15) | Fixed Asset Number | |
| LOCATION_CODES | VARCHAR2 | (30) | Location code | |
| IMPORT_MODE_CODE | VARCHAR2 | (80) | Import mode code | |
| IMPORT_MODE | NUMBER | Import Mode | ||
| IMPORT_SCOPE_CODE | VARCHAR2 | (80) | Import scope code | |
| IMPORT_SCOPE | NUMBER | Import Scope | ||
| OWNING_DEPARTMENT_CODE | VARCHAR2 | (10) | Owning Department Code | |
| ASSET_CRITICALITY_ID | NUMBER | Asset Criticality ID | ||
| CURRENT_STATUS | NUMBER | Current Status | ||
| PROD_ORGANIZATION_CODE | VARCHAR2 | (3) | Production Organization Code | |
| INSTANCE_NUMBER | VARCHAR2 | (30) | Instance Number | |
| ACTIVE_START_DATE | DATE | Active Start Date | ||
| ACTIVE_END_DATE | DATE | Active End Date | ||
| SUPPLIER_WARRANTY_EXP_DATE | DATE | Supplier Warranty Expiration Date | ||
| CHECKIN_STATUS | NUMBER | Checkin Status | ||
| OPERATIONAL_LOG_FLAG | VARCHAR2 | (1) | Operational Log Flag |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_GROUP_ID
, INTERFACE_HEADER_ID
, BATCH_ID
, BATCH_NAME
, PROCESS_FLAG_CODE
, PROCESS_FLAG
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PARENT_INVENTORY_ITEM_ID
, PARENT_SERIAL_NUMBER
, PARENT_INSTANCE_NUMBER
, DESCRIPTIVE_TEXT
, CURRENT_ORGANIZATION_ID
, WIP_ACCOUNTING_CLASS_CODE
, MAINTAINABLE_FLAG
, OWNING_DEPARTMENT_ID
, NETWORK_ASSET_FLAG
, FA_ASSET_ID
, PN_LOCATION_ID
, PN_LOCATION_NAME
, PN_LOCATION_CODE
, EAM_LOCATION_ID
, ASSET_CRITICALITY_CODE
, CATEGORY_ID
, ERROR_CODE
, ERROR_MESSAGE
, ORGANIZATION_CODE
, EQP_SERIAL_NUMBER
, EQUIPMENT_ITEM_ID
, PROD_ORGANIZATION_ID
, FA_ASSET_NUMBER
, LOCATION_CODES
, IMPORT_MODE_CODE
, IMPORT_MODE
, IMPORT_SCOPE_CODE
, IMPORT_SCOPE
, OWNING_DEPARTMENT_CODE
, ASSET_CRITICALITY_ID
, CURRENT_STATUS
, PROD_ORGANIZATION_CODE
, INSTANCE_NUMBER
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, SUPPLIER_WARRANTY_EXP_DATE
, CHECKIN_STATUS
, OPERATIONAL_LOG_FLAG
FROM APPS.MTL_EAM_ASSET_NUM_INTERFACE_V;
APPS
BOM_DEPARTMENTS
EAM_COMMON_UTILITIES_PVT
- show dependent code
MFG_LOOKUPS
MTL_EAM_ASSET_NUM_INTERFACE
MTL_EAM_LOCATIONS
MTL_PARAMETERS
PN_LOCATIONS_ALL
APPS.MTL_EAM_ASSET_NUM_INTERFACE_V is not referenced by any database object
|
|
|
|