[Home] [Help] [Dependency Information]
Object Name: | MSC_WIP_JOB_OPERATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_WIP_JOB_OPERATIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains the information about operations for existing discrete job or repetitive schedules
This view is used in XML outbound
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_HEADER_ID | NUMBER | Identifies this row's parent in job_schedule_interface | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
OPERATION_SEQ_ID | NUMBER | operation sequence id | ||
OPERATION_SEQ_CODE | VARCHAR2 | (4000) | Operation sequence code | |
FIRST_UNIT_START_DATE | DATE | First unit start date | ||
FIRST_UNIT_COMPLETION_DATE | DATE | First unit completion date | ||
LAST_UNIT_START_DATE | DATE | Last unit start date | ||
LAST_UNIT_COMPLETION_DATE | DATE | Last unit completion date | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
INSTANCE_CODE | VARCHAR2 | (3) | Yes | Source instance code |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_HEADER_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, OPERATION_SEQ_NUM
, OPERATION_SEQ_ID
, OPERATION_SEQ_CODE
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, SR_INSTANCE_ID
, INSTANCE_CODE
FROM APPS.MSC_WIP_JOB_OPERATIONS_V;
APPS.MSC_WIP_JOB_OPERATIONS_V is not referenced by any database object
|
|
|