VIEW: APPS.MSC_RESOURCE_INSTANCES_V

Source

View Text - Preformatted

SELECT inst.rowid ,inst.DEPT_RESOURCE_INST_ID ,inst.PLAN_ID ,inst.SR_INSTANCE_ID ,inst.RES_INSTANCE_ID ,inst.RESOURCE_ID ,mdr.DEPARTMENT_ID ,inst.ORGANIZATION_ID ,inst.SERIAL_NUMBER ,inst.EQUIPMENT_ITEM_ID ,msc_get_name.item_name(inst.EQUIPMENT_ITEM_ID,inst.ORGANIZATION_ID,inst.PLAN_ID,inst.SR_INSTANCE_ID) ,inst.EFFECTIVE_START_DATE ,inst.EFFECTIVE_END_DATE ,inst.LAST_KNOWN_SETUP ,setup.SETUP_CODE ,msc_get_name.get_equipment_desc(inst.PLAN_ID,inst.ORGANIZATION_ID,inst.SR_INSTANCE_ID,inst.EQUIPMENT_ITEM_ID) from msc_dept_res_instances inst, msc_department_resources mdr, msc_resource_setups setup WHERE inst.plan_id = mdr.plan_id and inst.sr_instance_id = mdr.sr_instance_id and inst.organization_id = mdr.organization_id and inst.department_id = nvl(mdr.owning_department_id,mdr.department_id) and inst.resource_id = mdr.resource_id and setup.RESOURCE_ID(+) = inst.RESOURCE_ID and setup.ORGANIZATION_ID(+) = inst.ORGANIZATION_ID and setup.plan_id(+) = inst.plan_id and setup.SETUP_ID(+) = inst.LAST_KNOWN_SETUP

View Text - HTML Formatted

SELECT INST.ROWID
, INST.DEPT_RESOURCE_INST_ID
, INST.PLAN_ID
, INST.SR_INSTANCE_ID
, INST.RES_INSTANCE_ID
, INST.RESOURCE_ID
, MDR.DEPARTMENT_ID
, INST.ORGANIZATION_ID
, INST.SERIAL_NUMBER
, INST.EQUIPMENT_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(INST.EQUIPMENT_ITEM_ID
, INST.ORGANIZATION_ID
, INST.PLAN_ID
, INST.SR_INSTANCE_ID)
, INST.EFFECTIVE_START_DATE
, INST.EFFECTIVE_END_DATE
, INST.LAST_KNOWN_SETUP
, SETUP.SETUP_CODE
, MSC_GET_NAME.GET_EQUIPMENT_DESC(INST.PLAN_ID
, INST.ORGANIZATION_ID
, INST.SR_INSTANCE_ID
, INST.EQUIPMENT_ITEM_ID)
FROM MSC_DEPT_RES_INSTANCES INST
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_RESOURCE_SETUPS SETUP
WHERE INST.PLAN_ID = MDR.PLAN_ID
AND INST.SR_INSTANCE_ID = MDR.SR_INSTANCE_ID
AND INST.ORGANIZATION_ID = MDR.ORGANIZATION_ID
AND INST.DEPARTMENT_ID = NVL(MDR.OWNING_DEPARTMENT_ID
, MDR.DEPARTMENT_ID)
AND INST.RESOURCE_ID = MDR.RESOURCE_ID
AND SETUP.RESOURCE_ID(+) = INST.RESOURCE_ID
AND SETUP.ORGANIZATION_ID(+) = INST.ORGANIZATION_ID
AND SETUP.PLAN_ID(+) = INST.PLAN_ID
AND SETUP.SETUP_ID(+) = INST.LAST_KNOWN_SETUP