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.

VIEW: APPS.MSC_NET_RES_INST_AVAIL_V

Source

View Text - Preformatted


SELECT RES.ROWID , RES.PLAN_ID,RES.shift_DATE , res.shift_num , to_char(res.shift_date+(res.from_time/86400.0),'HH24:MI:SS') , to_char(res.shift_date+(res.to_time/86400.0), 'HH24:MI:SS'), RES.ORGANIZATION_ID , RES.DEPARTMENT_ID , RES.RESOURCE_ID , RES.RES_INSTANCE_ID, RES.UPDATED,RES.STATUS , RES.APPLIED, res.sr_instance_id, RES.LAST_UPDATE_DATE , RES.LAST_UPDATED_BY , RES.CREATION_DATE, RES.CREATED_BY , RES.LAST_UPDATE_LOGIN , res.serial_number, res.simulation_set, res.from_time, res.to_time, nvl(res.capacity_units,1) from msc_net_res_inst_avail RES WHERE res.plan_id <> -1 union select R.ROWID , R.PLAN_ID,R.shift_DATE , r.shift_num , to_char(r.shift_date+(r.from_time/86400.0),'HH24:MI:SS') , to_char(r.shift_date+(r.to_time/86400.0), 'HH24:MI:SS'), R.ORGANIZATION_ID , R.DEPARTMENT_ID , R.RESOURCE_ID ,mdRi.RES_INSTANCE_ID, R.UPDATED,R.STATUS , R.APPLIED, r.sr_instance_id, R.LAST_UPDATE_DATE , R.LAST_UPDATED_BY , R.CREATION_DATE, R.CREATED_BY , R.LAST_UPDATE_LOGIN , mdri.serial_number, r.simulation_set, r.from_time, r.to_time, decode(r.capacity_units, null, 0, 0, 0, 1) from msc_net_resource_avail r, msc_department_resources mdr, msc_dept_res_instances mdri where r.parent_id is null and r.plan_id = -1 and mdr.organization_id = r.organization_id and mdr.sr_instance_id = r.sr_instance_id and mdr.plan_id = r.plan_id and mdr.department_id = r.department_id and mdr.resource_id = r.resource_id and mdr.organization_id = mdri.organization_id and mdr.sr_instance_id = mdri.sr_instance_id and mdr.plan_id = mdri.plan_id and nvl(mdr.owning_department_id,mdr.department_id) = mdri.department_id and mdr.resource_id = mdri.resource_id and not exists (select 1 from msc_net_res_inst_avail x where r.resource_id= x.resource_id and r.department_id= x.department_id and r.organization_id= x.organization_id and r.sr_instance_id=x.sr_instance_id and r.shift_date= x.shift_date and r.plan_id = x.plan_id and r.shift_num = r.shift_num and simulation_set is null) union select R.ROWID , R.PLAN_ID,R.shift_DATE , r.shift_num , to_char(r.shift_date+(r.from_time/86400.0),'HH24:MI:SS') , to_char(r.shift_date+(r.to_time/86400.0), 'HH24:MI:SS'), R.ORGANIZATION_ID , R.DEPARTMENT_ID , R.RESOURCE_ID ,R.RES_INSTANCE_ID, R.UPDATED,R.STATUS , R.APPLIED, r.sr_instance_id, R.LAST_UPDATE_DATE , R.LAST_UPDATED_BY , R.CREATION_DATE, R.CREATED_BY , R.LAST_UPDATE_LOGIN , r.serial_number, r.simulation_set, r.from_time, r.to_time, nvl( r.capacity_units,1) from msc_net_res_inst_avail r where r.parent_id is null and r.plan_id = -1

View Text - HTML Formatted

SELECT RES.ROWID
, RES.PLAN_ID
, RES.SHIFT_DATE
, RES.SHIFT_NUM
, TO_CHAR(RES.SHIFT_DATE+(RES.FROM_TIME/86400.0)
, 'HH24:MI:SS')
, TO_CHAR(RES.SHIFT_DATE+(RES.TO_TIME/86400.0)
, 'HH24:MI:SS')
, RES.ORGANIZATION_ID
, RES.DEPARTMENT_ID
, RES.RESOURCE_ID
, RES.RES_INSTANCE_ID
, RES.UPDATED
, RES.STATUS
, RES.APPLIED
, RES.SR_INSTANCE_ID
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
, RES.LAST_UPDATE_LOGIN
, RES.SERIAL_NUMBER
, RES.SIMULATION_SET
, RES.FROM_TIME
, RES.TO_TIME
, NVL(RES.CAPACITY_UNITS
, 1)
FROM MSC_NET_RES_INST_AVAIL RES
WHERE RES.PLAN_ID <> -1 UNION SELECT R.ROWID
, R.PLAN_ID
, R.SHIFT_DATE
, R.SHIFT_NUM
, TO_CHAR(R.SHIFT_DATE+(R.FROM_TIME/86400.0)
, 'HH24:MI:SS')
, TO_CHAR(R.SHIFT_DATE+(R.TO_TIME/86400.0)
, 'HH24:MI:SS')
, R.ORGANIZATION_ID
, R.DEPARTMENT_ID
, R.RESOURCE_ID
, MDRI.RES_INSTANCE_ID
, R.UPDATED
, R.STATUS
, R.APPLIED
, R.SR_INSTANCE_ID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, MDRI.SERIAL_NUMBER
, R.SIMULATION_SET
, R.FROM_TIME
, R.TO_TIME
, DECODE(R.CAPACITY_UNITS
, NULL
, 0
, 0
, 0
, 1)
FROM MSC_NET_RESOURCE_AVAIL R
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_DEPT_RES_INSTANCES MDRI
WHERE R.PARENT_ID IS NULL
AND R.PLAN_ID = -1
AND MDR.ORGANIZATION_ID = R.ORGANIZATION_ID
AND MDR.SR_INSTANCE_ID = R.SR_INSTANCE_ID
AND MDR.PLAN_ID = R.PLAN_ID
AND MDR.DEPARTMENT_ID = R.DEPARTMENT_ID
AND MDR.RESOURCE_ID = R.RESOURCE_ID
AND MDR.ORGANIZATION_ID = MDRI.ORGANIZATION_ID
AND MDR.SR_INSTANCE_ID = MDRI.SR_INSTANCE_ID
AND MDR.PLAN_ID = MDRI.PLAN_ID
AND NVL(MDR.OWNING_DEPARTMENT_ID
, MDR.DEPARTMENT_ID) = MDRI.DEPARTMENT_ID
AND MDR.RESOURCE_ID = MDRI.RESOURCE_ID
AND NOT EXISTS (SELECT 1
FROM MSC_NET_RES_INST_AVAIL X
WHERE R.RESOURCE_ID= X.RESOURCE_ID
AND R.DEPARTMENT_ID= X.DEPARTMENT_ID
AND R.ORGANIZATION_ID= X.ORGANIZATION_ID
AND R.SR_INSTANCE_ID=X.SR_INSTANCE_ID
AND R.SHIFT_DATE= X.SHIFT_DATE
AND R.PLAN_ID = X.PLAN_ID
AND R.SHIFT_NUM = R.SHIFT_NUM
AND SIMULATION_SET IS NULL) UNION SELECT R.ROWID
, R.PLAN_ID
, R.SHIFT_DATE
, R.SHIFT_NUM
, TO_CHAR(R.SHIFT_DATE+(R.FROM_TIME/86400.0)
, 'HH24:MI:SS')
, TO_CHAR(R.SHIFT_DATE+(R.TO_TIME/86400.0)
, 'HH24:MI:SS')
, R.ORGANIZATION_ID
, R.DEPARTMENT_ID
, R.RESOURCE_ID
, R.RES_INSTANCE_ID
, R.UPDATED
, R.STATUS
, R.APPLIED
, R.SR_INSTANCE_ID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.SERIAL_NUMBER
, R.SIMULATION_SET
, R.FROM_TIME
, R.TO_TIME
, NVL( R.CAPACITY_UNITS
, 1)
FROM MSC_NET_RES_INST_AVAIL R
WHERE R.PARENT_ID IS NULL
AND R.PLAN_ID = -1