[Home] [Help] [Dependency Information]
Object Name: | CS_MASS_SERVICE_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_SERVICE_TXNS_TEMP_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | MASS_SERVICE_TXN_TEMP_ID |
CS_MASS_SERVICE_TXNS_TEMP_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
CP_SERVICE_ID
RENEWAL_CRITERIA_SET |
CS_MASS_SERVICE_TXNS_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | RENEWAL_CRITERIA_SET |
CS_MASS_SERVICE_TXNS_TEMP_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CUSTOMER_ID |
CS_MASS_SERVICE_TXNS_TEMP_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | INVENTORY_ITEM_ID |
CS_MASS_SERVICE_TXNS_TEMP_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CP_SERIAL_NUMBER |
CS_MASS_SERVICE_TXNS_TEMP_N5 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SYSTEM_ID |
CS_MASS_SERVICE_TXNS_TEMP_N6 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PRODUCT_AGREEMENT_ID |
CS_MASS_SERVICE_TXNS_TEMP_N7 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SERVICE_AGREEMENT_ID |
CS_MASS_SERVICE_TXNS_TEMP_N8 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CUSTOMER_PRODUCT_ID |
CS_MASS_SERVICE_TXNS_TEMP_N9 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
SERVICE_INVENTORY_ITEM_ID
SERVICE_MANUFACTURING_ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_SERVICE_TXN_TEMP_ID | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
TRANSACTION_CODE | VARCHAR2 | (30) | Yes | |
RENEWAL_CRITERIA_SET | VARCHAR2 | (50) | Yes | |
CP_SERVICE_ID | NUMBER | (15) | 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) | ||
RENEWAL_DURATION_QUANTITY | NUMBER | (15) | ||
RENEWAL_UNIT_OF_MEASURE_CODE | VARCHAR2 | (25) | ||
RENEWAL_THROUGH_DATE | DATE | |||
TRANSACTION_REASON_CODE | VARCHAR2 | (30) | ||
TRANSACTION_COMMENTS | VARCHAR2 | (240) | ||
ORDER_TYPE_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
CP_SERIAL_NUMBER | VARCHAR2 | (10) | ||
CP_REVISION_ID | NUMBER | (15) | ||
SYSTEM_ID | NUMBER | (15) | ||
PRODUCT_AGREEMENT_ID | NUMBER | (15) | ||
SERVICE_AGREEMENT_ID | NUMBER | (15) | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
SERVICE_INVENTORY_ITEM_ID | NUMBER | (15) | ||
SERVICE_MANUFACTURING_ORG_ID | NUMBER | (15) | ||
SERVICE_START_DATE | DATE | |||
SERVICE_END_DATE | DATE | |||
SELECTED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_SERVICE_TXN_TEMP_ID
, CREATION_DATE
, CREATED_BY
, TRANSACTION_CODE
, RENEWAL_CRITERIA_SET
, CP_SERVICE_ID
, AVAILABLE_FLAG
, ORDERED_FLAG
, NOTIFIED_FLAG
, EXCEPTION_FLAG
, EXCEPTION_REASON_CODE
, ORDER_REQUEST_ID
, LETTER_REQUEST_ID
, RENEWAL_DURATION_QUANTITY
, RENEWAL_UNIT_OF_MEASURE_CODE
, RENEWAL_THROUGH_DATE
, TRANSACTION_REASON_CODE
, TRANSACTION_COMMENTS
, ORDER_TYPE_ID
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, CP_SERIAL_NUMBER
, CP_REVISION_ID
, SYSTEM_ID
, PRODUCT_AGREEMENT_ID
, SERVICE_AGREEMENT_ID
, CUSTOMER_PRODUCT_ID
, SERVICE_INVENTORY_ITEM_ID
, SERVICE_MANUFACTURING_ORG_ID
, SERVICE_START_DATE
, SERVICE_END_DATE
, SELECTED_FLAG
FROM CS.CS_MASS_SERVICE_TXNS_TEMP;
CS.CS_MASS_SERVICE_TXNS_TEMP does not reference any database object
CS.CS_MASS_SERVICE_TXNS_TEMP is referenced by following:
|
|
|