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_RESOURCES_V

Object Details

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

View Type

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

This view contains requests to add/delete/modify resource requirements for existing discrete jobs 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 id
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
RESOURCE_SEQ_NUM	NUMBER			Resource sequence number
RESOURCE_SEQ_CODE	VARCHAR2	(4000)		Resource sequence code
RESOURCE_ID_NEW	NUMBER			Resource identifier to be added/changed to
RESOURCE_CODE_NEW	VARCHAR2	(4000)		Resource code to be added/changed to
RESOURCE_ID_OLD	NUMBER			Resource identifier existing in current job/schedules
RESOURCE_CODE_OLD	VARCHAR2	(4000)		Resource code existing in current job/schedules
USAGE_RATE_OR_AMOUNT	NUMBER			Assembly or amount per job/schedule
ASSIGNED_UNITS	NUMBER			Number of resources assigned to do work
UOM_CODE	VARCHAR2	(3)		Unit of measure
START_DATE	DATE			Scheduled start date of the resource
COMPLETION_DATE	DATE			Scheduled completion date of the resource
DEPARTMENT_ID	NUMBER			Department Identifier
DEPARTMENT_CODE	VARCHAR2	(4000)		Department Code
ALTERNATE_NUM	NUMBER			Alternate Number
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
,      RESOURCE_SEQ_NUM
,      RESOURCE_SEQ_CODE
,      RESOURCE_ID_NEW
,      RESOURCE_CODE_NEW
,      RESOURCE_ID_OLD
,      RESOURCE_CODE_OLD
,      USAGE_RATE_OR_AMOUNT
,      ASSIGNED_UNITS
,      UOM_CODE
,      START_DATE
,      COMPLETION_DATE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      ALTERNATE_NUM
,      SR_INSTANCE_ID
,      INSTANCE_CODE
FROM APPS.MSC_WIP_JOB_RESOURCES_V;

Dependencies

[top of page]

APPS.MSC_WIP_JOB_RESOURCES_V references the following:

APPS: MSC_APPS_INSTANCES; MSC_ST_UTIL - show dependent code; MSC_TRADING_PARTNERS; MSC_WIP_JOB_DTLS_INTERFACE

APPS.MSC_WIP_JOB_RESOURCES_V is not referenced by any database object