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.

[Home] [Help]

View: MRP_AP_LINE_RESOURCES_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT WL.ORGANIZATION_ID
, WL.LINE_ID DEPARTMENT_ID
, WL.LINE_CODE DEPARTMENT_CODE
, 1 LINE_FLAG
, WL.MAXIMUM_RATE MAX_RATE
, WL.MINIMUM_RATE MIN_RATE
, WL.START_TIME
, WL.STOP_TIME
, WL.DESCRIPTION DEPARTMENT_DESCRIPTION
, WL.DISABLE_DATE LINE_DISABLE_DATE
, 1 AVAILABLE_24_HOURS_FLAG
, 1 CAPACITY_UNITS
, MPES.USER_TIME_FENCE
, MPES.OVER_UTILIZED_PERCENT
, MPES.UNDER_UTILIZED_PERCENT
, MPES.RESOURCE_SHORTAGE_TYPE
, MPES.RESOURCE_EXCESS_TYPE
, NVL(MPES.RN
, 0) RN3
, WL.RN RN2
, MP.RN RN1
FROM MRP_AP_PL_EX_SETS_SN MPES
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_WLINES_SN WL
WHERE WL.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MPES.EXCEPTION_SET_NAME(+)= WL.EXCEPTION_SET_NAME
AND MPES.ORGANIZATION_ID(+)= WL.ORGANIZATION_ID

Columns

Name
ORGANIZATION_ID
DEPARTMENT_ID
DEPARTMENT_CODE
LINE_FLAG
MAX_RATE
MIN_RATE
START_TIME
STOP_TIME
DEPARTMENT_DESCRIPTION
LINE_DISABLE_DATE
AVAILABLE_24_HOURS_FLAG
CAPACITY_UNITS
USER_TIME_FENCE
OVER_UTILIZED_PERCENT
UNDER_UTILIZED_PERCENT
RESOURCE_SHORTAGE_TYPE
RESOURCE_EXCESS_TYPE
RN3
RN2
RN1