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 Identifier
ASSET_NUMBER VARCHAR2 (30) Yes Asset/Instance Number
ASSET_DESCRIPTION VARCHAR2 (240)
Asset Description
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
Serial Number Flag
ORGANIZATION_ID NUMBER
Yes Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Name
ORGANIZATION_CODE VARCHAR2 (3)
Three letter Organization Code
INV_LOCATION_ORG_ID NUMBER

Inventory Locatory Organization Identifier
INV_LOCATION_ORG_NAME VARCHAR2 (240) Yes Inventory Location Org Name
INV_LOCATION_ORG_CODE VARCHAR2 (3)
Inventory Location Three Letter Org Code
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
CUSTOMER_PRODUCT_NAME VARCHAR2 (40)
Customer Product Name
CUSTOMER_PRODUCT_DESCRIPTION VARCHAR2 (240)
Customer Product Description
VERSION VARCHAR2 (3)
Version
SYSTEM_ID NUMBER

System Identifier
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 Identifier
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 Unit Of Measure Code
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Accounting Class Code
INSTANCE_CONDITION_ID NUMBER

Instance Condition Identifier
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 Identifier
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 Flag
SELLABLE_FLAG VARCHAR2 (1)
Sellable Flag
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type Code
LOCATION_ID NUMBER

Location Identifier
INV_ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INV_ORGANIZATION_NAME VARCHAR2 (240)
Inventory Organization Name
INV_ORGANIZATION_CODE VARCHAR2 (3)
Inventory Organization Code
INV_SUBINVENTORY_NAME VARCHAR2 (10)
Inventory Subinventory Name
INV_LOCATOR_ID NUMBER

Inventory Locator Identifier
PA_PROJECT_ID NUMBER

Project Identifier
PA_PROJECT_TASK_ID NUMBER

Project Task Identifier
IN_TRANSIT_ORDER_LINE_ID NUMBER

In Transit Order Line Identifier
WIP_JOB_ID NUMBER

Wip Job Identifier
PO_ORDER_LINE_ID NUMBER

PO Order Line Identifier
ORIGINAL_ORDER_LINE_ID NUMBER

Original Order Line Identifier
LAST_OE_RMA_LINE_ID NUMBER

Last RMA Line Identifier
LAST_PO_PO_LINE_ID NUMBER

Last PO Line Identifier
LAST_OE_PO_NUMBER VARCHAR2 (50)
Last PO Number
LAST_WIP_JOB_ID NUMBER

Last Wip Job Identifier
LAST_PA_PROJECT_ID NUMBER

Last Project Identifier
LAST_PA_TASK_ID NUMBER

Last Task Identifier
LAST_OE_AGREEMENT_ID NUMBER

Last Agreement Identifier
LAST_TXN_LINE_DETAIL_ID NUMBER

Last Transaction Line Detail Identifier
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 Identifier
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 Identifier
PARENT_ASSET_NUMBER VARCHAR2 (30)
Parent Asset Number
PARENT_ASSET_PRODUCT_NAME VARCHAR2 (40)
Parent Asset Product Name
ROOT_ASSET_ID NUMBER

Root Asset Identifier
SECURITY_GROUP_ID NUMBER

Security Group Identifier
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
CONFIG_INST_HDR_ID NUMBER

Configuration Instance Header Identifier
CONFIG_INST_REV_NUM NUMBER

Configuration Instance Revision Number
CONFIG_INST_ITEM_ID NUMBER

Configuration Instance Item Identifier
CONFIG_VALID_STATUS VARCHAR2 (30)
Configuration 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 Identifier
ASSET_CRITICALITY_CODE VARCHAR2 (30)
Asset Criticality Code
CATEGORY_ID NUMBER

Category Identifier
EQUIPMENT_GEN_OBJECT_ID NUMBER

Equipment Genealogy Object Identifier
INSTANTIATION_FLAG VARCHAR2 (1)
Instantiation Flag
LINEAR_LOCATION_ID NUMBER

Linear Location Identifier
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)
Attribute Category
ATTRIBUTE1 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE16 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE17 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE18 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE19 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE20 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE21 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE22 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE23 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE24 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE25 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE26 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE27 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE28 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE29 VARCHAR2 (240)
Standard DFF Column
ATTRIBUTE30 VARCHAR2 (240)
Standard DFF Column
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
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
,      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:

SchemaAPPS
SynonymCSI_II_RELATIONSHIPS
PL/SQL PackageCSI_II_RELATIONSHIPS_PVT - show dependent code
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_ITEM_INSTANCES
ViewCSI_LOOKUPS
ViewCSI_SYSTEMS_VL
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CSI_ASSET_INTEGRATION_R12_V is not referenced by any database object