[Home] [Help] [Dependency Information]
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 |
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
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 |
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;
APPS.MSC_WIP_JOB_RESOURCES_V is not referenced by any database object
|
|
|