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


VIEW: CSI.CSI_WEBADI_STAGING#

Object Details
Object Name: CSI_WEBADI_STAGING#
Object Type: VIEW
Owner: CSI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER

ORGANIZATION VARCHAR2 (240)
LAST_VLD_ORGANIZATION_ID NUMBER

INV_ORGANIZATION_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

REVISION_CONTROL_CODE NUMBER

INSTANCE_ID VARCHAR2 (240)
PRODUCT_NUMBER VARCHAR2 (30)
INSTANCE_DESCRIPTION VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_REV VARCHAR2 (3)
UOM VARCHAR2 (3)
QUANTITY NUMBER

SERIAL_NUMBER VARCHAR2 (30)
LOT_NUMBER VARCHAR2 (80)
INSTANCE_STATUS_NAME VARCHAR2 (50)
INSTANCE_STATUS_ID NUMBER

EXTERNAL_REF VARCHAR2 (30)
OPERATIONAL_STATUS_CODE VARCHAR2 (30)
OPERATIONAL_STATUS VARCHAR2 (80)
INTERNALLY_OWNED VARCHAR2 (1)
OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
OWNER_PARTY_TYPE VARCHAR2 (80)
OWNER_PARTY_NUM VARCHAR2 (30)
OWNER_NAME VARCHAR2 (360)
OWNER_ACCOUNT_NUMBER VARCHAR2 (30)
OWNER_ACCOUNT_NAME VARCHAR2 (240)
OWNER_ID NUMBER

OWNER_ACCOUNT_ID NUMBER

PARENT_INSTANCE VARCHAR2 (30)
OLD_PARENT_INSTANCE VARCHAR2 (30)
ROOT_INSTANCE VARCHAR2 (30)
SYSTEM_NAME VARCHAR2 (50)
SYSTEM_ID NUMBER

CREATE_CONTRACT VARCHAR2 (1)
LOCATION_TYPE_CODE VARCHAR2 (30)
CURRENT_LOCATION_PARTY VARCHAR2 (390)
CURRENT_LOC_PARTY_ID NUMBER

LOCATION_ID NUMBER

CURRENT_LOC_ADDRESS VARCHAR2 (899)
INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
INSTALL_LOCATION_PARTY VARCHAR2 (390)
INSTALL_LOCATION_PARTY_ID NUMBER

INSTALL_LOCATION_ID NUMBER

INSTALL_ADDRESS VARCHAR2 (899)
BILL_TO_LOC_PARTY_NUMBER VARCHAR2 (30)
BILL_TO_LOC_PARTY_NAME VARCHAR2 (360)
BILL_TO_LOC_PARTY_ID NUMBER

BILL_TO_LOCATION VARCHAR2 (30)
BILL_TO_ADDRESS VARCHAR2 (1207)
BILL_TO_LOC_ID NUMBER

SHIP_TO_LOC_PARTY_NUMBER VARCHAR2 (30)
SHIP_TO_LOC_PARTY_NAME VARCHAR2 (360)
SHIP_TO_LOC_PARTY_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (30)
SHIP_TO_ADDRESS VARCHAR2 (1207)
SHIP_TO_LOC_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

PRODUCT_TYPE_CODE VARCHAR2 (80)
INSTALL_DATE DATE

VERSION_LABEL VARCHAR2 (30)
CREATION_DATE DATE

ACTIVE_START_DATE DATE

EXPIRATION_DATE DATE

CONTRACT_NUMBER VARCHAR2 (2000)
ASSOCIATE_CONTRACT_NUMBER VARCHAR2 (120)
ASSOCIATE_CONTRACT_MODIFIER VARCHAR2 (120)
ASSOCIATE_SERVICE_LINE VARCHAR2 (100)
ASSOCIATE_CONTRACT_ID NUMBER

ASSOCIATE_SERVICE_LINE_ID NUMBER

SPLIT_QTY NUMBER

MERGE_INSTANCE VARCHAR2 (30)
CASCADE_UPDATE VARCHAR2 (1)
ASSOCIATE_BILL_TO_PARTY_TYPE VARCHAR2 (80)
ASSOCIATE_BILL_TO_PARTY_NUMBER VARCHAR2 (30)
ASSOCIATE_BILL_TO_PARTY_NAME VARCHAR2 (360)
ASSOCIATE_BILL_TO_PARTY_ID NUMBER

ASSOCIATE_BILL_TO_ACCT_NUM VARCHAR2 (30)
ASSOCIATE_BILL_TO_ACCT_ID NUMBER

ASSOCIATE_SHIP_TO_PARTY_TYPE VARCHAR2 (80)
ASSOCIATE_SHIP_TO_PARTY_NUMBER VARCHAR2 (30)
ASSOCIATE_SHIP_TO_PARTY_NAME VARCHAR2 (360)
ASSOCIATE_SHIP_TO_PARTY_ID NUMBER

ASSOCIATE_SHIP_TO_ACCT_NUM VARCHAR2 (30)
ASSOCIATE_SHIP_TO_ACCT_ID NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
BATCH_ID NUMBER

BATCH_NAME VARCHAR2 (100)
PROCESSING_STATUS VARCHAR2 (1)
PRICING_ATTRIBUTE_ID NUMBER

PRICING_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE1 VARCHAR2 (150)
PRICING_ATTRIBUTE2 VARCHAR2 (150)
PRICING_ATTRIBUTE3 VARCHAR2 (150)
PRICING_ATTRIBUTE4 VARCHAR2 (150)
PRICING_ATTRIBUTE5 VARCHAR2 (150)
PRICING_ATTRIBUTE6 VARCHAR2 (150)
PRICING_ATTRIBUTE7 VARCHAR2 (150)
PRICING_ATTRIBUTE8 VARCHAR2 (150)
PRICING_ATTRIBUTE9 VARCHAR2 (150)
PRICING_ATTRIBUTE10 VARCHAR2 (150)
PRICING_ATTRIBUTE11 VARCHAR2 (150)
PRICING_ATTRIBUTE12 VARCHAR2 (150)
PRICING_ATTRIBUTE13 VARCHAR2 (150)
PRICING_ATTRIBUTE14 VARCHAR2 (150)
PRICING_ATTRIBUTE15 VARCHAR2 (150)
PRICING_ATTRIBUTE16 VARCHAR2 (150)
PRICING_ATTRIBUTE17 VARCHAR2 (150)
PRICING_ATTRIBUTE18 VARCHAR2 (150)
PRICING_ATTRIBUTE19 VARCHAR2 (150)
PRICING_ATTRIBUTE20 VARCHAR2 (150)
PRICING_ATTRIBUTE21 VARCHAR2 (150)
PRICING_ATTRIBUTE22 VARCHAR2 (150)
PRICING_ATTRIBUTE23 VARCHAR2 (150)
PRICING_ATTRIBUTE24 VARCHAR2 (150)
PRICING_ATTRIBUTE25 VARCHAR2 (150)
PRICING_ATTRIBUTE26 VARCHAR2 (150)
PRICING_ATTRIBUTE27 VARCHAR2 (150)
PRICING_ATTRIBUTE28 VARCHAR2 (150)
PRICING_ATTRIBUTE29 VARCHAR2 (150)
PRICING_ATTRIBUTE30 VARCHAR2 (150)
PRICING_ATTRIBUTE31 VARCHAR2 (150)
PRICING_ATTRIBUTE32 VARCHAR2 (150)
PRICING_ATTRIBUTE33 VARCHAR2 (150)
PRICING_ATTRIBUTE34 VARCHAR2 (150)
PRICING_ATTRIBUTE35 VARCHAR2 (150)
PRICING_ATTRIBUTE36 VARCHAR2 (150)
PRICING_ATTRIBUTE37 VARCHAR2 (150)
PRICING_ATTRIBUTE38 VARCHAR2 (150)
PRICING_ATTRIBUTE39 VARCHAR2 (150)
PRICING_ATTRIBUTE40 VARCHAR2 (150)
PRICING_ATTRIBUTE41 VARCHAR2 (150)
PRICING_ATTRIBUTE42 VARCHAR2 (150)
PRICING_ATTRIBUTE43 VARCHAR2 (150)
PRICING_ATTRIBUTE44 VARCHAR2 (150)
PRICING_ATTRIBUTE45 VARCHAR2 (150)
PRICING_ATTRIBUTE46 VARCHAR2 (150)
PRICING_ATTRIBUTE47 VARCHAR2 (150)
PRICING_ATTRIBUTE48 VARCHAR2 (150)
PRICING_ATTRIBUTE49 VARCHAR2 (150)
PRICING_ATTRIBUTE50 VARCHAR2 (150)
PRICING_ATTRIBUTE51 VARCHAR2 (150)
PRICING_ATTRIBUTE52 VARCHAR2 (150)
PRICING_ATTRIBUTE53 VARCHAR2 (150)
PRICING_ATTRIBUTE54 VARCHAR2 (150)
PRICING_ATTRIBUTE55 VARCHAR2 (150)
PRICING_ATTRIBUTE56 VARCHAR2 (150)
PRICING_ATTRIBUTE57 VARCHAR2 (150)
PRICING_ATTRIBUTE58 VARCHAR2 (150)
PRICING_ATTRIBUTE59 VARCHAR2 (150)
PRICING_ATTRIBUTE60 VARCHAR2 (150)
PRICING_ATTRIBUTE61 VARCHAR2 (150)
PRICING_ATTRIBUTE62 VARCHAR2 (150)
PRICING_ATTRIBUTE63 VARCHAR2 (150)
PRICING_ATTRIBUTE64 VARCHAR2 (150)
PRICING_ATTRIBUTE65 VARCHAR2 (150)
PRICING_ATTRIBUTE66 VARCHAR2 (150)
PRICING_ATTRIBUTE67 VARCHAR2 (150)
PRICING_ATTRIBUTE68 VARCHAR2 (150)
PRICING_ATTRIBUTE69 VARCHAR2 (150)
PRICING_ATTRIBUTE70 VARCHAR2 (150)
PRICING_ATTRIBUTE71 VARCHAR2 (150)
PRICING_ATTRIBUTE72 VARCHAR2 (150)
PRICING_ATTRIBUTE73 VARCHAR2 (150)
PRICING_ATTRIBUTE74 VARCHAR2 (150)
PRICING_ATTRIBUTE75 VARCHAR2 (150)
PRICING_ATTRIBUTE76 VARCHAR2 (150)
PRICING_ATTRIBUTE77 VARCHAR2 (150)
PRICING_ATTRIBUTE78 VARCHAR2 (150)
PRICING_ATTRIBUTE79 VARCHAR2 (150)
PRICING_ATTRIBUTE80 VARCHAR2 (150)
PRICING_ATTRIBUTE81 VARCHAR2 (150)
PRICING_ATTRIBUTE82 VARCHAR2 (150)
PRICING_ATTRIBUTE83 VARCHAR2 (150)
PRICING_ATTRIBUTE84 VARCHAR2 (150)
PRICING_ATTRIBUTE85 VARCHAR2 (150)
PRICING_ATTRIBUTE86 VARCHAR2 (150)
PRICING_ATTRIBUTE87 VARCHAR2 (150)
PRICING_ATTRIBUTE88 VARCHAR2 (150)
PRICING_ATTRIBUTE89 VARCHAR2 (150)
PRICING_ATTRIBUTE90 VARCHAR2 (150)
PRICING_ATTRIBUTE91 VARCHAR2 (150)
PRICING_ATTRIBUTE92 VARCHAR2 (150)
PRICING_ATTRIBUTE93 VARCHAR2 (150)
PRICING_ATTRIBUTE94 VARCHAR2 (150)
PRICING_ATTRIBUTE95 VARCHAR2 (150)
PRICING_ATTRIBUTE96 VARCHAR2 (150)
PRICING_ATTRIBUTE97 VARCHAR2 (150)
PRICING_ATTRIBUTE98 VARCHAR2 (150)
PRICING_ATTRIBUTE99 VARCHAR2 (150)
PRICING_ATTRIBUTE100 VARCHAR2 (150)
Query Text

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


SELECT ITEM_ID
,      ORGANIZATION
,      LAST_VLD_ORGANIZATION_ID
,      INV_ORGANIZATION_ID
,      ITEM_NUMBER
,      SERIAL_NUMBER_CONTROL_CODE
,      LOT_CONTROL_CODE
,      REVISION_CONTROL_CODE
,      INSTANCE_ID
,      PRODUCT_NUMBER
,      INSTANCE_DESCRIPTION
,      ITEM_DESCRIPTION
,      ITEM_REV
,      UOM
,      QUANTITY
,      SERIAL_NUMBER
,      LOT_NUMBER
,      INSTANCE_STATUS_NAME
,      INSTANCE_STATUS_ID
,      EXTERNAL_REF
,      OPERATIONAL_STATUS_CODE
,      OPERATIONAL_STATUS
,      INTERNALLY_OWNED
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_TYPE
,      OWNER_PARTY_NUM
,      OWNER_NAME
,      OWNER_ACCOUNT_NUMBER
,      OWNER_ACCOUNT_NAME
,      OWNER_ID
,      OWNER_ACCOUNT_ID
,      PARENT_INSTANCE
,      OLD_PARENT_INSTANCE
,      ROOT_INSTANCE
,      SYSTEM_NAME
,      SYSTEM_ID
,      CREATE_CONTRACT
,      LOCATION_TYPE_CODE
,      CURRENT_LOCATION_PARTY
,      CURRENT_LOC_PARTY_ID
,      LOCATION_ID
,      CURRENT_LOC_ADDRESS
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_PARTY
,      INSTALL_LOCATION_PARTY_ID
,      INSTALL_LOCATION_ID
,      INSTALL_ADDRESS
,      BILL_TO_LOC_PARTY_NUMBER
,      BILL_TO_LOC_PARTY_NAME
,      BILL_TO_LOC_PARTY_ID
,      BILL_TO_LOCATION
,      BILL_TO_ADDRESS
,      BILL_TO_LOC_ID
,      SHIP_TO_LOC_PARTY_NUMBER
,      SHIP_TO_LOC_PARTY_NAME
,      SHIP_TO_LOC_PARTY_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS
,      SHIP_TO_LOC_ID
,      OBJECT_VERSION_NUMBER
,      PRODUCT_TYPE_CODE
,      INSTALL_DATE
,      VERSION_LABEL
,      CREATION_DATE
,      ACTIVE_START_DATE
,      EXPIRATION_DATE
,      CONTRACT_NUMBER
,      ASSOCIATE_CONTRACT_NUMBER
,      ASSOCIATE_CONTRACT_MODIFIER
,      ASSOCIATE_SERVICE_LINE
,      ASSOCIATE_CONTRACT_ID
,      ASSOCIATE_SERVICE_LINE_ID
,      SPLIT_QTY
,      MERGE_INSTANCE
,      CASCADE_UPDATE
,      ASSOCIATE_BILL_TO_PARTY_TYPE
,      ASSOCIATE_BILL_TO_PARTY_NUMBER
,      ASSOCIATE_BILL_TO_PARTY_NAME
,      ASSOCIATE_BILL_TO_PARTY_ID
,      ASSOCIATE_BILL_TO_ACCT_NUM
,      ASSOCIATE_BILL_TO_ACCT_ID
,      ASSOCIATE_SHIP_TO_PARTY_TYPE
,      ASSOCIATE_SHIP_TO_PARTY_NUMBER
,      ASSOCIATE_SHIP_TO_PARTY_NAME
,      ASSOCIATE_SHIP_TO_PARTY_ID
,      ASSOCIATE_SHIP_TO_ACCT_NUM
,      ASSOCIATE_SHIP_TO_ACCT_ID
,      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
,      BATCH_ID
,      BATCH_NAME
,      PROCESSING_STATUS
,      PRICING_ATTRIBUTE_ID
,      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
FROM CSI.CSI_WEBADI_STAGING#;

Dependencies

[top of page]

CSI.CSI_WEBADI_STAGING# references the following:

SchemaCSI
TableCSI_WEBADI_STAGING
CSI.CSI_WEBADI_STAGING# is referenced by following:

SchemaAPPS
SynonymCSI_WEBADI_STAGING