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

TABLE: CSD.CSD_WIP_TRANSACTION_DETAILS

Object Details
Object Name: CSD_WIP_TRANSACTION_DETAILS
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_WIP_TRANSACTION_DETAILS
Subobject Name:
Status: VALID


Transaction table for the High Volume Repair module.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSD_WIP_TRANSACTION_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_TRANSACTION_DETAIL_ID
CSD_WIP_TRANSACTION_DETAILS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnINVENTORY_ITEM_ID
ColumnOPERATION_SEQ_NUM
ColumnRESOURCE_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
WIP_TRANSACTION_DETAIL_ID NUMBER (15) Yes Primary key.
INVENTORY_ITEM_ID NUMBER (15)
Item identifier.
WIP_ENTITY_ID NUMBER (15) Yes WIP entity identifier.
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number.
RESOURCE_SEQ_NUM NUMBER

Resource sequence number.
EMPLOYEE_ID NUMBER (15)
Employee identifier.
TRANSACTION_QUANTITY NUMBER

Transaction quantity.
TRANSACTION_UOM VARCHAR2 (3)
Transaction UOM.
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
BACKFLUSH_FLAG NUMBER

Backflush flag.
COUNT_POINT_TYPE NUMBER

Count Point Type.
DEPARTMENT_ID NUMBER

Department identifier.
DESCRIPTION VARCHAR2 (240)
Description.
FIRST_UNIT_COMPLETION_DATE DATE

First Unit Completion date.
FIRST_UNIT_START_DATE DATE

First Unit Start date.
LAST_UNIT_COMPLETION_DATE DATE

Last Unit Completion date.
LAST_UNIT_START_DATE DATE

Last Unit Start date.
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum transfer quantity.
STANDARD_OPERATION_ID NUMBER

Standard operation identifier.
OBJECT_VERSION_NUMBER NUMBER
Yes Standard column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
REASON_ID NUMBER

Material Transaction Reason Id
REVISION VARCHAR2 (3)
Revision
Query Text

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


SELECT WIP_TRANSACTION_DETAIL_ID
,      INVENTORY_ITEM_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      EMPLOYEE_ID
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      SERIAL_NUMBER
,      BACKFLUSH_FLAG
,      COUNT_POINT_TYPE
,      DEPARTMENT_ID
,      DESCRIPTION
,      FIRST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      MINIMUM_TRANSFER_QUANTITY
,      STANDARD_OPERATION_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REASON_ID
,      REVISION
FROM CSD.CSD_WIP_TRANSACTION_DETAILS;

Dependencies

[top of page]

CSD.CSD_WIP_TRANSACTION_DETAILS does not reference any database object

CSD.CSD_WIP_TRANSACTION_DETAILS is referenced by following:

SchemaAPPS
SynonymCSD_WIP_TRANSACTION_DETAILS