VIEW: APPS.MSC_RESOURCE_INSTANCE_TREE_V

Source

View Text - Preformatted

SELECT mdr.plan_id, mdr.sr_instance_id, mdr.organization_id, mdr.resource_group_name, mdr.department_class, mdr.resource_code, mdr.resource_description, mdri.serial_number , mdri.equipment_item_id , mdr.department_id, mdr.resource_id, mdri.res_instance_id , msc_get_name.item_name(mdri.equipment_item_id , mdri.organization_id ,mdri.plan_id , mdri.sr_instance_id) item_name , mdr.batchable_flag , mdri.equipment_item_id inventory_item_id , mdr.line_flag, mdr.department_code FROM msc_department_resources mdr, msc_dept_res_instances mdri WHERE mdri.plan_id = mdr.plan_id AND mdri.sr_instance_id = mdr.sr_instance_id AND mdri.organization_id = mdr.organization_id AND mdri.department_id = nvl(mdr.owning_department_id, mdr.department_id) AND mdri.resource_id = mdr.resource_id

View Text - HTML Formatted

SELECT MDR.PLAN_ID
, MDR.SR_INSTANCE_ID
, MDR.ORGANIZATION_ID
, MDR.RESOURCE_GROUP_NAME
, MDR.DEPARTMENT_CLASS
, MDR.RESOURCE_CODE
, MDR.RESOURCE_DESCRIPTION
, MDRI.SERIAL_NUMBER
, MDRI.EQUIPMENT_ITEM_ID
, MDR.DEPARTMENT_ID
, MDR.RESOURCE_ID
, MDRI.RES_INSTANCE_ID
, MSC_GET_NAME.ITEM_NAME(MDRI.EQUIPMENT_ITEM_ID
, MDRI.ORGANIZATION_ID
, MDRI.PLAN_ID
, MDRI.SR_INSTANCE_ID) ITEM_NAME
, MDR.BATCHABLE_FLAG
, MDRI.EQUIPMENT_ITEM_ID INVENTORY_ITEM_ID
, MDR.LINE_FLAG
, MDR.DEPARTMENT_CODE
FROM MSC_DEPARTMENT_RESOURCES MDR
, MSC_DEPT_RES_INSTANCES MDRI
WHERE MDRI.PLAN_ID = MDR.PLAN_ID
AND MDRI.SR_INSTANCE_ID = MDR.SR_INSTANCE_ID
AND MDRI.ORGANIZATION_ID = MDR.ORGANIZATION_ID
AND MDRI.DEPARTMENT_ID = NVL(MDR.OWNING_DEPARTMENT_ID
, MDR.DEPARTMENT_ID)
AND MDRI.RESOURCE_ID = MDR.RESOURCE_ID