[Home] [Help]
[Dependency Information]
| Object Name: | CSI_INSTANCE_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | CSI |
| Subobject Name: | |
| Status: | VALID |
Cut, paste (and edit) the following text to query this object:
SELECT INST_INTERFACE_ID
, SOURCE_SYSTEM_NAME
, PARALLEL_WORKER_ID
, REPLACE_FLAG
, TRANSACTION_IDENTIFIER
, SOURCE_TRANSACTION_DATE
, SOURCE_TRANSACTION_TYPE
, INSTANCE_ID
, INSTANCE_NUMBER
, INSTANCE_DESCRIPTION
, EXTERNAL_REFERENCE
, PROCESS_STATUS
, BATCH_NAME
, ERROR_TEXT
, INVENTORY_ITEM_ID
, INV_CONCATENATED_SEGMENTS
, INVENTORY_REVISION
, INV_VLD_ORGANIZATION_ID
, INV_VLD_ORGANIZATION_NAME
, SERIAL_NUMBER
, MFG_SERIAL_NUMBER_FLAG
, LOT_NUMBER
, QUANTITY
, UNIT_OF_MEASURE_CODE
, UNIT_OF_MEASURE
, ACCOUNTING_CLASS_CODE
, INSTANCE_CONDITION_ID
, INSTANCE_CONDITION
, INSTANCE_STATUS_ID
, INSTANCE_STATUS
, CUSTOMER_VIEW_FLAG
, MERCHANT_VIEW_FLAG
, SELLABLE_FLAG
, SYSTEM_ID
, SYSTEM_NUMBER
, INSTANCE_START_DATE
, INSTANCE_END_DATE
, INSTANCE_TYPE_CODE
, LOCATION_TYPE_CODE
, LOCATION_ID
, INV_ORGANIZATION_ID
, INV_ORGANIZATION_CODE
, INV_ORGANIZATION_NAME
, INV_SUBINVENTORY_NAME
, INV_LOCATOR_NUMBER
, INV_LOCATOR_ID
, PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, TASK_NUMBER
, IN_TRANSIT_ORDER_LINE_ID
, IN_TRANSIT_ORDER_LINE_NUMBER
, WIP_JOB_ID
, WIP_JOB_NAME
, PO_ORDER_LINE_ID
, PO_ORDER_LINE_NUMBER
, OE_ORDER_LINE_ID
, OE_ORDER_LINE_NUMBER
, OE_RMA_LINE_ID
, OE_RMA_LINE_NUMBER
, PO_PO_LINE_ID
, PO_PO_LINE_NUMBER
, OE_PO_NUMBER
, OE_AGREEMENT_ID
, INSTALL_LOCATION_TYPE_CODE
, INSTALL_LOCATION_ID
, INSTALL_DATE
, RETURN_BY_DATE
, ACTUAL_RETURN_DATE
, CONFIG_INST_HDR_ID
, CONFIG_INST_REV_NUM
, CONFIG_INST_ITEM_ID
, CONFIG_VALID_STATUS
, INSTANCE_OU_ID
, OPERATING_UNIT_NAME
, OPERATING_UNIT
, OU_RELATION_TYPE
, OU_START_DATE
, OU_END_DATE
, INSTANCE_CONTEXT
, INSTANCE_ATTRIBUTE1
, INSTANCE_ATTRIBUTE2
, INSTANCE_ATTRIBUTE3
, INSTANCE_ATTRIBUTE4
, INSTANCE_ATTRIBUTE5
, INSTANCE_ATTRIBUTE6
, INSTANCE_ATTRIBUTE7
, INSTANCE_ATTRIBUTE8
, INSTANCE_ATTRIBUTE9
, INSTANCE_ATTRIBUTE10
, INSTANCE_ATTRIBUTE11
, INSTANCE_ATTRIBUTE12
, INSTANCE_ATTRIBUTE13
, INSTANCE_ATTRIBUTE14
, INSTANCE_ATTRIBUTE15
, PRICING_ATTRIBUTE_ID
, PRICING_ATT_START_DATE
, PRICING_ATT_END_DATE
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE60
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, PRICING_FLEX_CONTEXT
, PRICING_FLEX_ATTRIBUTE1
, PRICING_FLEX_ATTRIBUTE2
, PRICING_FLEX_ATTRIBUTE3
, PRICING_FLEX_ATTRIBUTE4
, PRICING_FLEX_ATTRIBUTE5
, PRICING_FLEX_ATTRIBUTE6
, PRICING_FLEX_ATTRIBUTE7
, PRICING_FLEX_ATTRIBUTE8
, PRICING_FLEX_ATTRIBUTE9
, PRICING_FLEX_ATTRIBUTE10
, PRICING_FLEX_ATTRIBUTE11
, PRICING_FLEX_ATTRIBUTE12
, PRICING_FLEX_ATTRIBUTE13
, PRICING_FLEX_ATTRIBUTE14
, PRICING_FLEX_ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NETWORK_ASSET_FLAG
, MAINTAINABLE_FLAG
, ASSET_CRITICALITY_CODE
, CATEGORY_ID
, EQUIPMENT_GEN_OBJECT_ID
, INSTANTIATION_FLAG
, OPERATIONAL_LOG_FLAG
, SUPPLIER_WARRANTY_EXP_DATE
, INSTANCE_ATTRIBUTE21
, INSTANCE_ATTRIBUTE16
, INSTANCE_ATTRIBUTE17
, INSTANCE_ATTRIBUTE18
, INSTANCE_ATTRIBUTE19
, INSTANCE_ATTRIBUTE20
, INSTANCE_ATTRIBUTE22
, INSTANCE_ATTRIBUTE23
, INSTANCE_ATTRIBUTE24
, INSTANCE_ATTRIBUTE25
, INSTANCE_ATTRIBUTE26
, INSTANCE_ATTRIBUTE27
, INSTANCE_ATTRIBUTE28
, INSTANCE_ATTRIBUTE29
, INSTANCE_ATTRIBUTE30
, SYNCUP_FAMILY
, OPERATIONAL_STATUS_CODE
FROM CSI.CSI_INSTANCE_INTERFACE#;
CSI
CSI_INSTANCE_INTERFACE
APPS
CSI_INSTANCE_INTERFACE
|
|
|
|