eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSI_ASSET_INTEGRATION_R12_V

Object Details

Object Name:	CSI_ASSET_INTEGRATION_R12_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Provide details of an item instance for asset integration.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_PRODUCT_ID	NUMBER		Yes	Customer Product Id
OPERATING_UNIT_ID	NUMBER			operating unit id of the sold from org
ASSET_NUMBER	VARCHAR2	(30)	Yes	Asset number
ASSET_DESCRIPTION	VARCHAR2	(240)		Asset Description
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number
MFG_SERIAL_NUMBER_FLAG	VARCHAR2	(1)		MFG Serial number Flag
ORGANIZATION_ID	NUMBER		Yes	Organization Id
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
INV_LOCATION_ORG_ID	NUMBER			Inv location Org Id
INV_LOCATION_ORG_NAME	VARCHAR2	(240)	Yes	Inv location Org name
INV_LOCATION_ORG_CODE	VARCHAR2	(3)		Inv location org code
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item Id
CUSTOMER_PRODUCT_NAME	VARCHAR2	(40)		Customer Product name
CUSTOMER_PRODUCT_DESCRIPTION	VARCHAR2	(240)		Customer Product Description
VERSION	VARCHAR2	(3)		Version
SYSTEM_ID	NUMBER			System id
SYSTEM_NAME	VARCHAR2	(50)		System Name
SYSTEM_DESCRIPTION	VARCHAR2	(240)		System Description
SYSTEM_TYPE_CODE	VARCHAR2	(30)		System Type Code
SYSTEM_NUMBER	VARCHAR2	(30)		System Number
OWNER_PARTY_SOURCE_TABLE	VARCHAR2	(30)		Owner Party Source Table
OWNER_PARTY_ID	NUMBER			Owner Party Id
OWNER_ACCOUNT_ID	NUMBER			Owner Account id
OWNER_ACCOUNT_NAME	VARCHAR2	(240)		Owner Account Name
OWNER_ACCOUNT_NUMBER	VARCHAR2	(30)		Owner Account Number
CUSTOMER_ID	NUMBER			Customer Id
CUSTOMER_NAME	VARCHAR2	(240)		Customer Name
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number
EXTERNAL_REFERENCE	VARCHAR2	(30)		External reference
LOT_NUMBER	VARCHAR2	(80)		Lot Number
QUANTITY	NUMBER		Yes	Quantity
UNIT_OF_MEASURE_CODE	VARCHAR2	(3)	Yes	Code for Unit of Measure
ACCOUNTING_CLASS_CODE	VARCHAR2	(10)		Accounting Class Code
INSTANCE_CONDITION_ID	NUMBER			Instance Condition Id
INSTANCE_USAGE_CODE	VARCHAR2	(30)		Instance Usage Code
INSTANCE_TYPE_CODE	VARCHAR2	(30)		Instance type code
INSTANCE_TYPE_MEANING	VARCHAR2	(80)		Instance type meaning
STATUS_ID	NUMBER		Yes	Status Id
STATUS_CODE	VARCHAR2	(50)	Yes	Status Code
STAUTS_DESCRIPTION	VARCHAR2	(240)		status Description
CUSTOMER_VIEW_FLAG	VARCHAR2	(1)	Yes	customer view flag
MERCHANT_VIEW_FLAG	VARCHAR2	(1)	Yes	merchant view falg
SELLABLE_FLAG	VARCHAR2	(1)		Sellable flag
LOCATION_TYPE_CODE	VARCHAR2	(30)		Location Type Code
LOCATION_ID	NUMBER			Location Id
INV_ORGANIZATION_ID	NUMBER			Inventory Organization Id
INV_ORGANIZATION_NAME	VARCHAR2	(240)		Inventory Organization name
INV_ORGANIZATION_CODE	VARCHAR2	(3)		Inventory Organization Code
INV_SUBINVENTORY_NAME	VARCHAR2	(10)		Subinventory Name
INV_LOCATOR_ID	NUMBER			Locator Id
PA_PROJECT_ID	NUMBER			Project Id
PA_PROJECT_TASK_ID	NUMBER			Task Id
IN_TRANSIT_ORDER_LINE_ID	NUMBER			In Transit Order line Id
WIP_JOB_ID	NUMBER			WIP job ID
PO_ORDER_LINE_ID	NUMBER			PO Order line id
ORIGINAL_ORDER_LINE_ID	NUMBER			Original order line id
LAST_OE_RMA_LINE_ID	NUMBER			Last RMA Line id
LAST_PO_PO_LINE_ID	NUMBER			Last PO line ID
LAST_OE_PO_NUMBER	VARCHAR2	(50)		Last PO Number
LAST_WIP_JOB_ID	NUMBER			Last WIP job Id
LAST_PA_PROJECT_ID	NUMBER			Last Project Id
LAST_PA_TASK_ID	NUMBER			Last Task Id
LAST_OE_AGREEMENT_ID	NUMBER			Last Agreement Id
LAST_TXN_LINE_DETAIL_ID	NUMBER			Last Transaction Line Detail Id
MANUALLY_CREATED_FLAG	VARCHAR2	(1)		Manually created flag
INSTALL_DATE	DATE			Install date
INSTALL_LOCATION_TYPE_CODE	VARCHAR2	(30)		Install Location type Code
INSTALL_LOCATION_ID	NUMBER			Install Location Id
RETURN_BY_DATE	DATE			Return by date
ACTUAL_RETURN_DATE	DATE			Actual return date
ACTIVE_START_DATE	DATE			Active start date
ACTIVE_END_DATE	DATE			Active end date
CREATION_COMPLETE_FLAG	VARCHAR2	(1)		Creation Complete Flag
COMPLETENESS_FLAG	VARCHAR2	(1)		Completeness flag
PARENT_ASSET_ID	NUMBER			Parent Asset Id
PARENT_ASSET_NUMBER	VARCHAR2	(30)		Parent Asset number
PARENT_ASSET_PRODUCT_NAME	VARCHAR2	(40)		Parent asset product name
ROOT_ASSET_ID	NUMBER			Root asset Id
SECURITY_GROUP_ID	NUMBER			Security group Id
MIGRATED_FLAG	VARCHAR2	(1)		Migrated flag
REQUEST_ID	NUMBER			Request Id
PROGRAM_APPLICATION_ID	NUMBER			Program application Id
PROGRAM_ID	NUMBER			Program Id
PROGRAM_UPDATE_DATE	DATE			Program update date
CONFIG_INST_HDR_ID	NUMBER			Config Instance Header Id
CONFIG_INST_REV_NUM	NUMBER			Config Instance Revision Number
CONFIG_INST_ITEM_ID	NUMBER			Config Instance Item Id
CONFIG_VALID_STATUS	VARCHAR2	(30)		Config Valid status
LAST_PURGE_DATE	DATE			Last purge date
NETWORK_ASSET_FLAG	VARCHAR2	(1)		Network asset flag
MAINTAINABLE_FLAG	VARCHAR2	(1)		Maintainable flag
PN_LOCATION_ID	NUMBER			Pn location Id
ASSET_CRITICALITY_CODE	VARCHAR2	(30)		Asset criticality code
CATEGORY_ID	NUMBER			Catogory Id
EQUIPMENT_GEN_OBJECT_ID	NUMBER			Equipment Gen. Object Id
INSTANTIATION_FLAG	VARCHAR2	(1)		Instantiation flag
LINEAR_LOCATION_ID	NUMBER			Linear location Id
OPERATIONAL_LOG_FLAG	VARCHAR2	(1)		Operational log flag
CHECKIN_STATUS	NUMBER			checkin status
SUPPLIER_WARRANTY_EXP_DATE	DATE			Supplier warranty expiry 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
SOURCE_CODE	VARCHAR2	(10)		Source code
CONTEXT	VARCHAR2	(30)		DFF context
ATTRIBUTE1	VARCHAR2	(240)		DFF attribute
ATTRIBUTE2	VARCHAR2	(240)		DFF attribute
ATTRIBUTE3	VARCHAR2	(240)		DFF attribute
ATTRIBUTE4	VARCHAR2	(240)		DFF attribute
ATTRIBUTE5	VARCHAR2	(240)		DFF attribute
ATTRIBUTE6	VARCHAR2	(240)		DFF attribute
ATTRIBUTE7	VARCHAR2	(240)		DFF attribute
ATTRIBUTE8	VARCHAR2	(240)		DFF attribute
ATTRIBUTE9	VARCHAR2	(240)		DFF attribute
ATTRIBUTE10	VARCHAR2	(240)		DFF attribute
ATTRIBUTE11	VARCHAR2	(240)		DFF attribute
ATTRIBUTE12	VARCHAR2	(240)		DFF attribute
ATTRIBUTE13	VARCHAR2	(240)		DFF attribute
ATTRIBUTE14	VARCHAR2	(240)		DFF attribute
ATTRIBUTE15	VARCHAR2	(240)		DFF attribute
ATTRIBUTE16	VARCHAR2	(240)		DFF attribute
ATTRIBUTE17	VARCHAR2	(240)		DFF attribute
ATTRIBUTE18	VARCHAR2	(240)		DFF attribute
ATTRIBUTE19	VARCHAR2	(240)		DFF attribute
ATTRIBUTE20	VARCHAR2	(240)		DFF attribute
ATTRIBUTE21	VARCHAR2	(240)		DFF attribute
ATTRIBUTE22	VARCHAR2	(240)		DFF attribute
ATTRIBUTE23	VARCHAR2	(240)		DFF attribute
ATTRIBUTE24	VARCHAR2	(240)		DFF attribute
ATTRIBUTE25	VARCHAR2	(240)		DFF attribute
ATTRIBUTE26	VARCHAR2	(240)		DFF attribute
ATTRIBUTE27	VARCHAR2	(240)		DFF attribute
ATTRIBUTE28	VARCHAR2	(240)		DFF attribute
ATTRIBUTE29	VARCHAR2	(240)		DFF attribute
ATTRIBUTE30	VARCHAR2	(240)		DFF attribute
CREATED_BY	NUMBER	(15)	Yes	Created by
CREATION_DATE	DATE		Yes	Creation date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last updated by
LAST_UPDATE_DATE	DATE		Yes	Last update date
LAST_UPDATE_LOGIN	NUMBER	(15)		Last update login
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number

Query Text

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


SELECT CUSTOMER_PRODUCT_ID
,      OPERATING_UNIT_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      INV_LOCATION_ORG_ID
,      INV_LOCATION_ORG_NAME
,      INV_LOCATION_ORG_CODE
,      INVENTORY_ITEM_ID
,      CUSTOMER_PRODUCT_NAME
,      CUSTOMER_PRODUCT_DESCRIPTION
,      VERSION
,      SYSTEM_ID
,      SYSTEM_NAME
,      SYSTEM_DESCRIPTION
,      SYSTEM_TYPE_CODE
,      SYSTEM_NUMBER
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_ID
,      OWNER_ACCOUNT_ID
,      OWNER_ACCOUNT_NAME
,      OWNER_ACCOUNT_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      EXTERNAL_REFERENCE
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      ACCOUNTING_CLASS_CODE
,      INSTANCE_CONDITION_ID
,      INSTANCE_USAGE_CODE
,      INSTANCE_TYPE_CODE
,      INSTANCE_TYPE_MEANING
,      STATUS_ID
,      STATUS_CODE
,      STAUTS_DESCRIPTION
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      SELLABLE_FLAG
,      LOCATION_TYPE_CODE
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_ORGANIZATION_NAME
,      INV_ORGANIZATION_CODE
,      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
,      ORIGINAL_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
,      LAST_TXN_LINE_DETAIL_ID
,      MANUALLY_CREATED_FLAG
,      INSTALL_DATE
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      RETURN_BY_DATE
,      ACTUAL_RETURN_DATE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      PARENT_ASSET_ID
,      PARENT_ASSET_NUMBER
,      PARENT_ASSET_PRODUCT_NAME
,      ROOT_ASSET_ID
,      SECURITY_GROUP_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
,      CHECKIN_STATUS
,      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
,      SOURCE_CODE
,      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
FROM APPS.CSI_ASSET_INTEGRATION_R12_V;

Dependencies

[top of page]

APPS.CSI_ASSET_INTEGRATION_R12_V references the following:

APPS: CSI_II_RELATIONSHIPS; CSI_II_RELATIONSHIPS_PVT - show dependent code; CSI_INSTANCE_STATUSES; CSI_ITEM_INSTANCES; CSI_I_ORG_ASSIGNMENTS; CSI_LOOKUPS; CSI_SYSTEMS_VL; HR_ALL_ORGANIZATION_UNITS; HZ_CUST_ACCOUNTS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV

APPS.CSI_ASSET_INTEGRATION_R12_V is not referenced by any database object