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

VIEW: APPS.EAM_CHECKED_OUT_ASSETS_V

Object Details
Object Name: EAM_CHECKED_OUT_ASSETS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEAM.EAM_CHECKED_OUT_ASSETS_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
ROW_ID ROWID (10)
Row Id
INSTANCE_ID NUMBER
Yes Unique ID that identifies an item unit instance ( Internally generated sequence number )
EXTERNAL_REFERENCE VARCHAR2 (30)
External reference, like customer asset tag
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier from MTL_SYSTEM_ITEMS_B
INVENTORY_REVISION VARCHAR2 (3)
Inventory Revision Code
INV_MASTER_ORGANIZATION_ID NUMBER
Yes Inventory Master Organization Identifier from MTL_ORGANIZATIONS
SERIAL_NUMBER VARCHAR2 (30)
Serial Number of the Instance
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
Flag indicating if the Serial Number is a manufacturers Serial number
LOT_NUMBER VARCHAR2 (80)
Lot Number
QUANTITY NUMBER
Yes Quantity
UNIT_OF_MEASURE VARCHAR2 (3) Yes Unit of Measure Code
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Accounting Classification Code
INSTANCE_CONDITION_ID NUMBER

Instance Condition Identifier
INSTANCE_STATUS_ID NUMBER
Yes Instance Status Identifier
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the Instance is as per the Customer Definition
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the instance is as per the Merchant View
SELLABLE_FLAG VARCHAR2 (1)
Flag indicating if the Instance is sellable
SYSTEM_ID NUMBER

System Identifier to which the Instance is a part of
INSTANCE_TYPE_CODE VARCHAR2 (30)
Instance Type Code
ACTIVE_START_DATE DATE

Activation Start Date
ACTIVE_END_DATE DATE

Activation End Date
LOCATION_ID NUMBER

Location Identifier
INV_ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INV_SUBINVENTORY_NAME VARCHAR2 (10)
Inventory Sub-Inventory Name
INV_LOCATOR_ID NUMBER

Inventory Locator Identifier
PA_PROJECT_ID NUMBER

Project Identifier from Project Accounting
PA_PROJECT_TASK_ID NUMBER

Project Task Identifier from Project Accounting
IN_TRANSIT_ORDER_LINE_ID NUMBER

Order Line Identifier for an In-Transit Order (Internal Order)
WIP_JOB_ID NUMBER

WIP Job Identifier
PO_ORDER_LINE_ID NUMBER

Purchase Order Line Identifier
LAST_OE_ORDER_LINE_ID NUMBER

Last Order Line Idetifier that touched the Instance
LAST_OE_RMA_LINE_ID NUMBER

Last RMA Line Identifier that touched the Instance
LAST_PO_PO_LINE_ID NUMBER

Last Purchase Order Line Identifier from Purchasing
LAST_OE_PO_NUMBER VARCHAR2 (50)
Last Order Entry Purchase Order Number
LAST_WIP_JOB_ID NUMBER

Last WIP job Identifier
LAST_PA_PROJECT_ID NUMBER

Last Project Identifier from Project Accounting
LAST_PA_TASK_ID NUMBER

Last Task Identifier from Project Accounting
LAST_OE_AGREEMENT_ID NUMBER

Last Agreement Identifier from Order Entry
INSTALL_DATE DATE

Installation Date for an Instance
MANUALLY_CREATED_FLAG VARCHAR2 (1)
Flag indicating if the instance is created manually
RETURN_BY_DATE DATE

Date the Instance to be returned
ACTUAL_RETURN_DATE DATE

Date of the Actual Return
CREATION_COMPLETE_FLAG VARCHAR2 (1)
Flag indicating if the Instance Creation is complete
COMPLETENESS_FLAG VARCHAR2 (1)
Flag indicating if the Instance Configuration is Complete
CONTEXT VARCHAR2 (30)
Standard DFF Columns
ATTRIBUTE1 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE2 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE3 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE4 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE5 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE6 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE7 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE8 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE9 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE10 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE11 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE12 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE13 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE14 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE15 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE16 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE17 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE18 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE19 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE20 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE21 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE22 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE23 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE24 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE25 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE26 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE27 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE28 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE29 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE30 VARCHAR2 (240)
Standard DFF Columns
CREATED_BY NUMBER (15) Yes Standard WHO Columns
CREATION_DATE DATE
Yes Standard WHO Columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Columns
LAST_UPDATE_DATE DATE
Yes Standard WHO Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Columns
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
SECURITY_GROUP_ID NUMBER

Security Group Identifier
LAST_TXN_LINE_DETAIL_ID NUMBER

Transaction Line Detail Identifier
INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
Install Location Type Code
INSTALL_LOCATION_ID NUMBER

Install Location Identifier
INSTANCE_USAGE_CODE VARCHAR2 (30)
Instance Usage Code
OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
De-normalized Column for Instance Owner Party Source Table
OWNER_PARTY_ID NUMBER

De-normalized Column for Instance Owner Party Identifier
OWNER_PARTY_ACCOUNT_ID NUMBER

De-normalized Column for Instance Owner Party Account Identifier
LAST_VLD_ORGANIZATION_ID NUMBER

The Organization Identifier by which the Instance was validated Last
MIGRATED_FLAG VARCHAR2 (1)
Flag indicating if the record is migrated
REQUEST_ID NUMBER

Party / Account Merge
PROGRAM_APPLICATION_ID NUMBER

Party / Account Merge
PROGRAM_ID NUMBER

Party / Account Merge
PROGRAM_UPDATE_DATE DATE

Party / Account Merge
CONFIG_INST_HDR_ID NUMBER

Configuration Instance Header Identified from Configurator
CONFIG_INST_REV_NUM NUMBER

Configuration Instance Header Revision Number Configurator
CONFIG_INST_ITEM_ID NUMBER

Configuration Instance Item Identified from Configurator
CONFIG_VALID_STATUS VARCHAR2 (30)
Configurator Validation Status. 1. Valid 2.Invalid
LAST_PURGE_DATE DATE

Last history purge date for this item instance
NETWORK_ASSET_FLAG VARCHAR2 (1)
eAM Network Asset Flag
MAINTAINABLE_FLAG VARCHAR2 (1)
eAM Maintainable Flag
PN_LOCATION_ID NUMBER

eAM PN Location Id
ASSET_CRITICALITY_CODE VARCHAR2 (30)
eAM Asset Criticality Code
CATEGORY_ID NUMBER

eAM Category Id
EQUIPMENT_GEN_OBJECT_ID NUMBER

eAM Equipment Object Id
INSTANTIATION_FLAG VARCHAR2 (1)
eAM Instantiation Flag
LINEAR_LOCATION_ID NUMBER

eAM Linear Location Id
OPERATIONAL_LOG_FLAG VARCHAR2 (1)
eAM Operational Log Flag
SUPPLIER_WARRANTY_EXP_DATE DATE

eAM Supplier Warranty Expiration Date
PURCHASE_UNIT_PRICE NUMBER

Purchase Unit Price
PURCHASE_CURRENCY_CODE VARCHAR2 (15)
Purchase Currency Code
PAYABLES_UNIT_PRICE NUMBER

Payables Unit Price
PAYABLES_CURRENCY_CODE VARCHAR2 (15)
Payables Currency Code
SALES_UNIT_PRICE NUMBER

Sales Unit Price
SALES_CURRENCY_CODE VARCHAR2 (15)
Sales Currency Code
OPERATIONAL_STATUS_CODE VARCHAR2 (30)
Operational Status Code
ASSET_DESC VARCHAR2 (240)
Item Instance Description
TXN_DATE DATE
Yes Transaction date
USER_ID NUMBER
Yes Employee identifier carrying out the transaction
CHECKIN_STATUS NUMBER

eAM Checkin Status Indicator
ASSET_NUMBER VARCHAR2 (30) Yes Functional, user key to the item instance
MAINT_ORGANIZATION_ID NUMBER

Maintenance Organization Identifier
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type
Query Text

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


SELECT ROW_ID
,      INSTANCE_ID
,      EXTERNAL_REFERENCE
,      INVENTORY_ITEM_ID
,      INVENTORY_REVISION
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACCOUNTING_CLASS_CODE
,      INSTANCE_CONDITION_ID
,      INSTANCE_STATUS_ID
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      SELLABLE_FLAG
,      SYSTEM_ID
,      INSTANCE_TYPE_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      PA_PROJECT_ID
,      PA_PROJECT_TASK_ID
,      IN_TRANSIT_ORDER_LINE_ID
,      WIP_JOB_ID
,      PO_ORDER_LINE_ID
,      LAST_OE_ORDER_LINE_ID
,      LAST_OE_RMA_LINE_ID
,      LAST_PO_PO_LINE_ID
,      LAST_OE_PO_NUMBER
,      LAST_WIP_JOB_ID
,      LAST_PA_PROJECT_ID
,      LAST_PA_TASK_ID
,      LAST_OE_AGREEMENT_ID
,      INSTALL_DATE
,      MANUALLY_CREATED_FLAG
,      RETURN_BY_DATE
,      ACTUAL_RETURN_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      LAST_TXN_LINE_DETAIL_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      INSTANCE_USAGE_CODE
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_ID
,      OWNER_PARTY_ACCOUNT_ID
,      LAST_VLD_ORGANIZATION_ID
,      MIGRATED_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONFIG_INST_HDR_ID
,      CONFIG_INST_REV_NUM
,      CONFIG_INST_ITEM_ID
,      CONFIG_VALID_STATUS
,      LAST_PURGE_DATE
,      NETWORK_ASSET_FLAG
,      MAINTAINABLE_FLAG
,      PN_LOCATION_ID
,      ASSET_CRITICALITY_CODE
,      CATEGORY_ID
,      EQUIPMENT_GEN_OBJECT_ID
,      INSTANTIATION_FLAG
,      LINEAR_LOCATION_ID
,      OPERATIONAL_LOG_FLAG
,      SUPPLIER_WARRANTY_EXP_DATE
,      PURCHASE_UNIT_PRICE
,      PURCHASE_CURRENCY_CODE
,      PAYABLES_UNIT_PRICE
,      PAYABLES_CURRENCY_CODE
,      SALES_UNIT_PRICE
,      SALES_CURRENCY_CODE
,      OPERATIONAL_STATUS_CODE
,      ASSET_DESC
,      TXN_DATE
,      USER_ID
,      CHECKIN_STATUS
,      ASSET_NUMBER
,      MAINT_ORGANIZATION_ID
,      LOCATION_TYPE_CODE
FROM APPS.EAM_CHECKED_OUT_ASSETS_V;

Dependencies

[top of page]

APPS.EAM_CHECKED_OUT_ASSETS_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymEAM_ASSET_OPERATION_TXN
SynonymMTL_PARAMETERS

APPS.EAM_CHECKED_OUT_ASSETS_V is not referenced by any database object