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

TABLE: WIP.WIP_SCHEDULING_INTERFACE

Object Details
Object Name: WIP_SCHEDULING_INTERFACE
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_SCHEDULING_INTERFACE
Subobject Name:
Status: VALID


WIP_SCHEDULING_INTERFACE contains schedule date information for jobs at the operation or resource level. To set the schedule dates for a particular operation or resource, you must insert a row with the appropriate parameters into the WIP_SCHEDULING_INTERFACE table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_SCHEDULING_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER

Unique Identifier
GROUP_ID NUMBER
Yes Group Identifier for batching interface records
WIP_ENTITY_ID NUMBER
Yes WIP entity Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence
RESOURCE_SEQ_NUM NUMBER

Resource requirement sequence
SCHEDULING_LEVEL NUMBER
Yes Indicates whether record is at operation or resource requirement level
OPERATION_START_DATE DATE

Operation start date
OPERATION_COMPLETION_DATE DATE

Operation completion date
RESOURCE_START_DATE DATE

Resource requirement start date
RESOURCE_COMPLETION_DATE DATE

Resource requirement completion date
USAGE_RATE_OR_AMOUNT NUMBER

Resource requirement usage rate or amount
PROCESS_PHASE NUMBER
Yes Process phase
PROCESS_STATUS NUMBER
Yes Process status
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
Query Text

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


SELECT INTERFACE_ID
,      GROUP_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      SCHEDULING_LEVEL
,      OPERATION_START_DATE
,      OPERATION_COMPLETION_DATE
,      RESOURCE_START_DATE
,      RESOURCE_COMPLETION_DATE
,      USAGE_RATE_OR_AMOUNT
,      PROCESS_PHASE
,      PROCESS_STATUS
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
FROM WIP.WIP_SCHEDULING_INTERFACE;

Dependencies

[top of page]

WIP.WIP_SCHEDULING_INTERFACE does not reference any database object

WIP.WIP_SCHEDULING_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_SCHEDULING_INTERFACE#