VIEW: APPS.MSC_RESOURCE_PARAMETERS_V

Source

View Text - Preformatted

SELECT MRS.ROWID, MRS.ORGANIZATION_ID , MTP.ORGANIZATION_CODE, MRS.SR_INSTANCE_ID , MRS.DEPARTMENT_ID, MDR.DEPARTMENT_CODE, MRS.RESOURCE_ID, MDR.RESOURCE_CODE, MDR.RESOURCE_DESCRIPTION, MRS.RESOURCE_TYPE, msc_get_name.lookup_meaning('MSC_RESOURCE_TYPE',MRS.RESOURCE_TYPE), MDR.BATCHABLE_FLAG, MRS.AVAILABLE_SPOTS, MRS.CRO, MRS.MIN_CYCLE_TIME, MRS.MIN_CYCLE_TIME_UNIT, msc_get_name.lookup_meaning('MSC_TIME_UOM',MRS.MIN_CYCLE_TIME_UNIT), MRS.MIN_CHANGE_BET_CYCLES, MRS.OFFLOAD_PERCENTAGE, MRS.OFFLOAD_WINDOW, MRS.OFFLOAD_WINDOW_UNIT, msc_get_name.lookup_meaning('MSC_TIME_UOM',MRS.OFFLOAD_WINDOW_UNIT), MRS.INV_RELEASE_INTERVAL, MRS.INV_REL_INTERVAL_UNIT, msc_get_name.lookup_meaning('MSC_TIME_UOM',MRS.INV_REL_INTERVAL_UNIT), MRS.LAST_UPDATE_DATE, MRS.LAST_UPDATED_BY, MRS.CREATION_DATE, MRS.CREATED_BY, MRS.LAST_UPDATE_LOGIN, MRS.MINIMIZE_IDLE_TIME, MRS.SCHEDULE_OBJECTIVE, MRS.CHGOVER_PREBUILD_MAX, MRS.CHGOVER_PREBUILD_MAX_UOM from MSC_DEPARTMENT_RESOURCES MDR, MSC_RESOURCE_PARAMETERS MRS, MSC_TRADING_PARTNERS MTP WHERE MDR.PLAN_ID = -1 AND MDR.LINE_FLAG = 2 AND MDR.ORGANIZATION_ID = MRS.ORGANIZATION_ID AND MDR.SR_INSTANCE_ID = MRS.SR_INSTANCE_ID AND MDR.DEPARTMENT_ID = MRS.DEPARTMENT_ID AND MDR.RESOURCE_ID = MRS.RESOURCE_ID AND MRS.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID AND MRS.ORGANIZATION_ID = MTP.SR_TP_ID AND MTP.PARTNER_TYPE = 3

View Text - HTML Formatted

SELECT MRS.ROWID
, MRS.ORGANIZATION_ID
, MTP.ORGANIZATION_CODE
, MRS.SR_INSTANCE_ID
, MRS.DEPARTMENT_ID
, MDR.DEPARTMENT_CODE
, MRS.RESOURCE_ID
, MDR.RESOURCE_CODE
, MDR.RESOURCE_DESCRIPTION
, MRS.RESOURCE_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MSC_RESOURCE_TYPE'
, MRS.RESOURCE_TYPE)
, MDR.BATCHABLE_FLAG
, MRS.AVAILABLE_SPOTS
, MRS.CRO
, MRS.MIN_CYCLE_TIME
, MRS.MIN_CYCLE_TIME_UNIT
, MSC_GET_NAME.LOOKUP_MEANING('MSC_TIME_UOM'
, MRS.MIN_CYCLE_TIME_UNIT)
, MRS.MIN_CHANGE_BET_CYCLES
, MRS.OFFLOAD_PERCENTAGE
, MRS.OFFLOAD_WINDOW
, MRS.OFFLOAD_WINDOW_UNIT
, MSC_GET_NAME.LOOKUP_MEANING('MSC_TIME_UOM'
, MRS.OFFLOAD_WINDOW_UNIT)
, MRS.INV_RELEASE_INTERVAL
, MRS.INV_REL_INTERVAL_UNIT
, MSC_GET_NAME.LOOKUP_MEANING('MSC_TIME_UOM'
, MRS.INV_REL_INTERVAL_UNIT)
, MRS.LAST_UPDATE_DATE
, MRS.LAST_UPDATED_BY
, MRS.CREATION_DATE
, MRS.CREATED_BY
, MRS.LAST_UPDATE_LOGIN
, MRS.MINIMIZE_IDLE_TIME
, MRS.SCHEDULE_OBJECTIVE
, MRS.CHGOVER_PREBUILD_MAX
, MRS.CHGOVER_PREBUILD_MAX_UOM
FROM MSC_DEPARTMENT_RESOURCES MDR
, MSC_RESOURCE_PARAMETERS MRS
, MSC_TRADING_PARTNERS MTP
WHERE MDR.PLAN_ID = -1
AND MDR.LINE_FLAG = 2
AND MDR.ORGANIZATION_ID = MRS.ORGANIZATION_ID
AND MDR.SR_INSTANCE_ID = MRS.SR_INSTANCE_ID
AND MDR.DEPARTMENT_ID = MRS.DEPARTMENT_ID
AND MDR.RESOURCE_ID = MRS.RESOURCE_ID
AND MRS.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MRS.ORGANIZATION_ID = MTP.SR_TP_ID
AND MTP.PARTNER_TYPE = 3