[Home] [Help] [Dependency Information]
Object Name: | CS_MASS_NOTIFICATION_TXNS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_MASS_NOTIFICATION_TXNS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | MASS_NOTIFICATION_TXN_TEMP_ID |
CS_MASS_NOTIFICATION_TXNS_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
CUSTOMER_PRODUCT_ID
UPDATE_CRITERIA_SET |
CS_MASS_NOTIFICATION_TXNS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | UPDATE_CRITERIA_SET |
CS_MASS_NOTIFICATION_TXNS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | INVENTORY_ITEM_ID |
CS_MASS_NOTIFICATION_TXNS_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CUSTOMER_ID |
CS_MASS_NOTIFICATION_TXNS_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SYSTEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_NOTIFICATION_TXN_TEMP_ID | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
TRANSACTION_CODE | VARCHAR2 | (30) | Yes | |
UPDATE_CRITERIA_SET | VARCHAR2 | (50) | Yes | |
CUSTOMER_PRODUCT_ID | NUMBER | (15) | Yes | |
CUSTOMER_ID | NUMBER | (15) | Yes | |
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | |
CP_SERIAL_NUMBER | VARCHAR2 | (10) | Yes | |
AVAILABLE_FLAG | VARCHAR2 | (1) | Yes | |
ORDERED_FLAG | VARCHAR2 | (1) | Yes | |
NOTIFIED_FLAG | VARCHAR2 | (1) | Yes | |
EXCEPTION_FLAG | VARCHAR2 | (1) | Yes | |
EXCEPTION_REASON_CODE | VARCHAR2 | (30) | ||
ORDER_REQUEST_ID | NUMBER | (15) | ||
LETTER_REQUEST_ID | NUMBER | (15) | ||
SYSTEM_ID | NUMBER | (15) | ||
CP_REVISION | VARCHAR2 | (15) | ||
SERVICE_AGREEMENT_ID | NUMBER | (15) | ||
PRODUCT_AGREEMENT_ID | NUMBER | (15) | ||
ORDER_TYPE_ID | NUMBER | (15) | ||
UPDATE_MODEL_ID | NUMBER | (15) | ||
UPDATE_INVENTORY_ITEM_ID | NUMBER | (15) | ||
UPDATE_MANUFACTURING_ORG_ID | NUMBER | (15) | ||
CP_TRANSACTION_TYPE_ID | NUMBER | (15) | ||
CP_ATTRIBUTE1 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE2 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE3 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE4 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE5 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE6 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE7 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE8 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE9 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE10 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE11 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE12 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE13 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE14 | VARCHAR2 | (150) | ||
CP_ATTRIBUTE15 | VARCHAR2 | (150) | ||
CP_CONTEXT | VARCHAR2 | (30) | ||
SELECTED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_NOTIFICATION_TXN_TEMP_ID
, CREATION_DATE
, CREATED_BY
, TRANSACTION_CODE
, UPDATE_CRITERIA_SET
, CUSTOMER_PRODUCT_ID
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, CP_SERIAL_NUMBER
, AVAILABLE_FLAG
, ORDERED_FLAG
, NOTIFIED_FLAG
, EXCEPTION_FLAG
, EXCEPTION_REASON_CODE
, ORDER_REQUEST_ID
, LETTER_REQUEST_ID
, SYSTEM_ID
, CP_REVISION
, SERVICE_AGREEMENT_ID
, PRODUCT_AGREEMENT_ID
, ORDER_TYPE_ID
, UPDATE_MODEL_ID
, UPDATE_INVENTORY_ITEM_ID
, UPDATE_MANUFACTURING_ORG_ID
, CP_TRANSACTION_TYPE_ID
, CP_ATTRIBUTE1
, CP_ATTRIBUTE2
, CP_ATTRIBUTE3
, CP_ATTRIBUTE4
, CP_ATTRIBUTE5
, CP_ATTRIBUTE6
, CP_ATTRIBUTE7
, CP_ATTRIBUTE8
, CP_ATTRIBUTE9
, CP_ATTRIBUTE10
, CP_ATTRIBUTE11
, CP_ATTRIBUTE12
, CP_ATTRIBUTE13
, CP_ATTRIBUTE14
, CP_ATTRIBUTE15
, CP_CONTEXT
, SELECTED_FLAG
FROM CS.CS_MASS_NOTIFICATION_TXNS_TEMP;
CS.CS_MASS_NOTIFICATION_TXNS_TEMP does not reference any database object
CS.CS_MASS_NOTIFICATION_TXNS_TEMP is referenced by following:
|
|
|