[Home] [Help] [Dependency Information]
Object Name: | CSI_ASSET_INTEGRATION_R12_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Provide details of an item instance for asset integration.
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 |
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;
APPS.CSI_ASSET_INTEGRATION_R12_V is not referenced by any database object
|
|
|