[Home] [Help] [Dependency Information]
Object Name: | CSI_DIAGNOSTICS_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIAG_SEQ_ID | NUMBER | Yes | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
MTL_TXN_DATE | DATE | |||
MTL_TXN_ID | NUMBER | |||
MTL_TXN_NAME | VARCHAR2 | (240) | ||
MTL_TXN_QTY | NUMBER | |||
MTL_TYPE_ID | NUMBER | |||
MTL_ACTION_ID | NUMBER | |||
MTL_SRC_TYPE_ID | NUMBER | |||
MTL_TYPE_CLASS | NUMBER | |||
SOURCE_TYPE | VARCHAR2 | (30) | ||
CSI_TXN_TYPE_ID | NUMBER | |||
CSI_TXN_ID | NUMBER | |||
ERROR_FLAG | VARCHAR2 | (1) | ||
ERROR_TEXT | VARCHAR2 | (2000) | ||
INVENTORY_ITEM_ID | NUMBER | |||
SERIAL_CONTROL_CODE | NUMBER | |||
LOT_CONTROL_CODE | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (80) | ||
ORGANIZATION_ID | NUMBER | |||
OE_ORDER_LINE_ID | NUMBER | |||
WIP_JOB_ID | NUMBER | |||
OE_RMA_LINE_ID | NUMBER | |||
INSTANCE_ID | NUMBER | |||
INSTANCE_VLD_ORGANIZATION_ID | NUMBER | |||
INSTANCE_LOCATION | VARCHAR2 | (30) | ||
INSTANCE_USAGE_CODE | VARCHAR2 | (30) | ||
INSTANCE_ORGANIZATION_ID | NUMBER | |||
INSTANCE_SUBINV_NAME | VARCHAR2 | (80) | ||
INSTANCE_REVISION | VARCHAR2 | (3) | ||
INSTANCE_END_DATE | DATE | |||
INSTANCE_OWNER_PARTY_ID | NUMBER | |||
INSTANCE_OWNER_ACCOUNT_ID | NUMBER | |||
INSTANCE_MIG_FLAG | VARCHAR2 | (1) | ||
INTERNAL_PARTY_ID | NUMBER | |||
LAST_TRANSACTION_FLAG | VARCHAR2 | (1) | ||
ENTANGLED_FLAG | VARCHAR2 | (1) | ||
CREATE_FLAG | VARCHAR2 | (1) | ||
EXPIRE_FLAG | VARCHAR2 | (1) | ||
PROCESS_CODE | VARCHAR2 | (30) | ||
PROCESS_FLAG | VARCHAR2 | (1) | ||
TEMPORARY_MESSAGE | VARCHAR2 | (2000) | ||
MTL_CREATION_DATE | DATE | |||
REVISION_CONTROL_CODE | NUMBER | |||
MTL_XFER_TXN_ID | NUMBER | |||
MTL_ITEM_REVISION | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT DIAG_SEQ_ID
, SERIAL_NUMBER
, MTL_TXN_DATE
, MTL_TXN_ID
, MTL_TXN_NAME
, MTL_TXN_QTY
, MTL_TYPE_ID
, MTL_ACTION_ID
, MTL_SRC_TYPE_ID
, MTL_TYPE_CLASS
, SOURCE_TYPE
, CSI_TXN_TYPE_ID
, CSI_TXN_ID
, ERROR_FLAG
, ERROR_TEXT
, INVENTORY_ITEM_ID
, SERIAL_CONTROL_CODE
, LOT_CONTROL_CODE
, LOT_NUMBER
, ORGANIZATION_ID
, OE_ORDER_LINE_ID
, WIP_JOB_ID
, OE_RMA_LINE_ID
, INSTANCE_ID
, INSTANCE_VLD_ORGANIZATION_ID
, INSTANCE_LOCATION
, INSTANCE_USAGE_CODE
, INSTANCE_ORGANIZATION_ID
, INSTANCE_SUBINV_NAME
, INSTANCE_REVISION
, INSTANCE_END_DATE
, INSTANCE_OWNER_PARTY_ID
, INSTANCE_OWNER_ACCOUNT_ID
, INSTANCE_MIG_FLAG
, INTERNAL_PARTY_ID
, LAST_TRANSACTION_FLAG
, ENTANGLED_FLAG
, CREATE_FLAG
, EXPIRE_FLAG
, PROCESS_CODE
, PROCESS_FLAG
, TEMPORARY_MESSAGE
, MTL_CREATION_DATE
, REVISION_CONTROL_CODE
, MTL_XFER_TXN_ID
, MTL_ITEM_REVISION
FROM CSI.CSI_DIAGNOSTICS_TEMP#;
|
|
|