[Home] [Help] [Dependency Information]
Object Name: | CSD_WIP_TRANSACTION_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | CSD |
FND Design Data: | CSD.CSD_WIP_TRANSACTION_DETAILS |
Subobject Name: | |
Status: | VALID |
Transaction table for the High Volume Repair module.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSD_WIP_TRANSACTION_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | WIP_TRANSACTION_DETAIL_ID |
CSD_WIP_TRANSACTION_DETAILS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WIP_ENTITY_ID
INVENTORY_ITEM_ID OPERATION_SEQ_NUM RESOURCE_SEQ_NUM |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATE_RO_FLAG | VARCHAR2 | (1) | Indicates whether or not a repair order can be auto-created for this row. Specific to materials only. Values can be FND_API.G _TRUE and FND_API.G_FALSE. A NULL value would have equivalent behavior to FND_API.G_FALSE. | |
QUANTITY_ISSUED | NUMBER | Keeps track of the total quantity issued to the job. In otherwords this column keeps the summation of quantity for operation-item combo for a WIP job where transaction type id is 35. | ||
QUANTITY_RECOVERED | NUMBER | Keeps track of the total quantity recovered from the job. In otherwords this column keeps the summation of quantity for operation-item combo for a WIP job where transaction type id is 43. | ||
SUBSTITUTES | NUMBER | Holds the value of the item substituted by this item when the original part was requested using the Request Parts functionality. If the same item substitutes multiple items on the same operation then the value of the substituted item will be the latest one. | ||
IS_SUBSTITUTED | VARCHAR2 | (1) | Holds a value of Y for a material requirement line if the material requirement line is substituted by a different material. |
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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATE_RO_FLAG
, QUANTITY_ISSUED
, QUANTITY_RECOVERED
, SUBSTITUTES
, IS_SUBSTITUTED
FROM CSD.CSD_WIP_TRANSACTION_DETAILS;
CSD.CSD_WIP_TRANSACTION_DETAILS does not reference any database object
CSD.CSD_WIP_TRANSACTION_DETAILS is referenced by following:
|
|
|