eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSC_WIP_JOB_SCHEDULE_V

Object Details

Object Name:	MSC_WIP_JOB_SCHEDULE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_WIP_JOB_SCHEDULE_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains request to create or modify discrete jobs or repetitive schedules. This view is used in XML-outbound

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_LINE_ID	NUMBER			Identifier of the source system that generated the interface record
ORGANIZATION_ID	NUMBER			Organization ID
PARTNER_NAME	VARCHAR2	(255)	Yes	Partner name
ORGANIZATION_CODE	VARCHAR2	(7)		Organization Code
STATUS_TYPE	NUMBER			Status of the job or repetitive schedule to be loaded
STATUS	VARCHAR2	(80)	Yes	Status
LAST_UNIT_COMPLETION_DATE	DATE			Date, job or schedule should end
LINE_ID	NUMBER			WIP line identifier
LINE_CODE	VARCHAR2	(4000)		Line Code
PRIMARY_ITEM_ID	NUMBER			Inventory item identifier of the assembly the job or repetitive schedule creates
PRIMARY_ITEM_NAME	VARCHAR2	(4000)		Primary item name
CLASS_CODE	VARCHAR2	(10)		Accounting class associated with job or repetitive assembly
JOB_NAME	VARCHAR2	(4000)		WIP job name
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing used in a job or repetitive schedule
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate bill of material used in a job or repetitive schedule
START_QUANTITY	NUMBER			Job start quantity
BUILD_SEQUENCE	NUMBER			Build sequence
PROJECT_ID	NUMBER			Project Identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project Number
TASK_ID	NUMBER			Task Identifier
TASK_NUMBER	VARCHAR2	(4000)		Task Number
NET_QUANTITY	NUMBER			Job net quantity
UOM_CODE	VARCHAR2	(3)		Unit of measure code
SR_INSTANCE_ID	NUMBER			Source application instance identifier
INSTANCE_CODE	VARCHAR2	(3)	Yes	Source instance code
BILL_RTG_EXPLOSION_FLAG	VARCHAR2	(1)		Bill routing explosion flag
FIRST_UNIT_START_DATE	DATE			Date job or schedule should start
BOM_REFERENCE_ID	NUMBER			BOM reference ID
BOM_NAME	VARCHAR2	(4000)		Bill of material name
ROUTING_REFERENCE_ID	NUMBER			Routing reference ID
ROUTING_NAME	VARCHAR2	(4000)		Routing Name
COPRODUCTS_SUPPLY	VARCHAR2	(3)		Co-product supply

Query Text

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


SELECT SOURCE_LINE_ID
,      ORGANIZATION_ID
,      PARTNER_NAME
,      ORGANIZATION_CODE
,      STATUS_TYPE
,      STATUS
,      LAST_UNIT_COMPLETION_DATE
,      LINE_ID
,      LINE_CODE
,      PRIMARY_ITEM_ID
,      PRIMARY_ITEM_NAME
,      CLASS_CODE
,      JOB_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      START_QUANTITY
,      BUILD_SEQUENCE
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      NET_QUANTITY
,      UOM_CODE
,      SR_INSTANCE_ID
,      INSTANCE_CODE
,      BILL_RTG_EXPLOSION_FLAG
,      FIRST_UNIT_START_DATE
,      BOM_REFERENCE_ID
,      BOM_NAME
,      ROUTING_REFERENCE_ID
,      ROUTING_NAME
,      COPRODUCTS_SUPPLY
FROM APPS.MSC_WIP_JOB_SCHEDULE_V;

Dependencies

[top of page]

APPS.MSC_WIP_JOB_SCHEDULE_V references the following:

APPS: MFG_LOOKUPS; MSC_APPS_INSTANCES; MSC_ST_UTIL - show dependent code; MSC_TRADING_PARTNERS; MSC_WIP_JOB_SCHEDULE_INTERFACE

APPS.MSC_WIP_JOB_SCHEDULE_V is not referenced by any database object