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

VIEW: APPS.MSC_WIP_JOB_OPERATIONS_V

Object Details
Object Name: MSC_WIP_JOB_OPERATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_WIP_JOB_OPERATIONS_V
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSC_WIP_JOB_OPERATIONS_V references the following:

SchemaAPPS
SynonymMSC_APPS_INSTANCES
PL/SQL PackageMSC_ST_UTIL - show dependent code
SynonymMSC_TRADING_PARTNERS
SynonymMSC_WIP_JOB_DTLS_INTERFACE

APPS.MSC_WIP_JOB_OPERATIONS_V is not referenced by any database object