[Home] [Help] [Dependency Information]
Object Name: | WIP_TIME_ENTRY_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
WIP_TIME_ENTRY_INTERFACE contains requests to create
time entry records .Users can use this table to load
data into WIP from external sources . WIP_TIME_ENTRY_DATA
concurrent program processes rows in this table.
Scope: public
Product: WIP
Lifecycle: active
Display Name: WIP Time Entry Interface
Category: BUSINESS_ENTITY MES_TIME_ENTRY
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_TIME_ENTRY_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTERFACE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ID | NUMBER | Yes | Interface Identifier | |
TIME_ENTRY_TYPE | NUMBER | Yes | Time Entry Identifier | |
ORGANIZATION_ID | NUMBER | Organization Identifer | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
WIP_ENTITY_ID | NUMBER | Job Identifier | ||
JOB_NAME | VARCHAR2 | (240) | Job Name | |
OPERATION_SEQ_NUM | NUMBER | Operation Sequence Identifer | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department Code | |
DEPARTMENT_ID | NUMBER | Department Identifier | ||
RESOURCE_SEQ_NUM | NUMBER | Resource Seq Number | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource Code | |
RESOURCE_ID | NUMBER | Resource Identifier | ||
UOM_CODE | VARCHAR2 | (3) | Yes | UOM Code |
EMPLOYEE_ID | NUMBER | Person Identifier | ||
ACTUAL_START_DATE | DATE | Yes | Actual Start Date | |
ACTUAL_END_DATE | DATE | Actual End Date | ||
DURATION | NUMBER | Duration | ||
ACTION_FLAG | NUMBER | Action Flag | ||
REQUEST_ID | NUMBER | Enhanced Who Column | ||
ERROR | VARCHAR2 | (240) | Error Message | |
PROCESS_STATUS | NUMBER | Process Status | ||
PROGRAM_ID | NUMBER | Enhanced Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Enhance Who Column | ||
BADGE_ID | VARCHAR2 | (30) | Employee Number |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, TIME_ENTRY_TYPE
, ORGANIZATION_ID
, ORGANIZATION_CODE
, WIP_ENTITY_ID
, JOB_NAME
, OPERATION_SEQ_NUM
, DEPARTMENT_CODE
, DEPARTMENT_ID
, RESOURCE_SEQ_NUM
, RESOURCE_CODE
, RESOURCE_ID
, UOM_CODE
, EMPLOYEE_ID
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, DURATION
, ACTION_FLAG
, REQUEST_ID
, ERROR
, PROCESS_STATUS
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, BADGE_ID
FROM WIP.WIP_TIME_ENTRY_INTERFACE;
WIP.WIP_TIME_ENTRY_INTERFACE does not reference any database object
WIP.WIP_TIME_ENTRY_INTERFACE is referenced by following:
|
|
|