VIEW: APPS.MTL_EAM_EQUIP_RESOURCES_V

Source

View Text - Preformatted

SELECT bdr.rowid row_id, bre.organization_id, bre.inventory_item_id , bdri.serial_number, bre.resource_id, br.resource_code, br.description, bre.instance_id, bdr.department_id, bd.department_code, bdr.share_from_dept_id, bd1.department_code share_from_dept_code, decode(bd1.department_code, null, bd.department_code, bd1.department_code) owning_department_code, bdr.capacity_units, bdr.available_24_hours_flag, bdr.resource_group_name, bdr.share_capacity_flag, br.unit_of_measure, br.autocharge_type, bdr.ctp_flag, bdr.schedule_to_instance FROM bom_dept_res_instances bdri, bom_resource_equipments bre, bom_resources br, bom_department_resources bdr, bom_departments bd, bom_departments bd1 WHERE bdri.resource_id = bre.resource_id and bdri.instance_id = bre.instance_id and br.organization_id = bre.organization_id and br.resource_id = bre.resource_id and decode(bdr.share_from_dept_id, null, bdr.department_id, bdr.share_from_dept_id) = bdri.department_id and bdr.resource_id = bre.resource_id and bd.department_id = bdr.department_id and bd1.department_id(+) = bdr.share_from_dept_id union select row_id, organization_id, inventory_item_id, serial_number, resource_id, resource_code, description, instance_id, department_id, department_code, share_from_dept_id, share_from_dept_code, owning_department_code, capacity_units, available_24_hours_flag, resource_group_name, share_capacity_flag, unit_of_measure, autocharge_type, ctp_flag, schedule_to_instance from gmp_eam_equip_resources_v

View Text - HTML Formatted

SELECT BDR.ROWID ROW_ID
, BRE.ORGANIZATION_ID
, BRE.INVENTORY_ITEM_ID
, BDRI.SERIAL_NUMBER
, BRE.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BRE.INSTANCE_ID
, BDR.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BDR.SHARE_FROM_DEPT_ID
, BD1.DEPARTMENT_CODE SHARE_FROM_DEPT_CODE
, DECODE(BD1.DEPARTMENT_CODE
, NULL
, BD.DEPARTMENT_CODE
, BD1.DEPARTMENT_CODE) OWNING_DEPARTMENT_CODE
, BDR.CAPACITY_UNITS
, BDR.AVAILABLE_24_HOURS_FLAG
, BDR.RESOURCE_GROUP_NAME
, BDR.SHARE_CAPACITY_FLAG
, BR.UNIT_OF_MEASURE
, BR.AUTOCHARGE_TYPE
, BDR.CTP_FLAG
, BDR.SCHEDULE_TO_INSTANCE
FROM BOM_DEPT_RES_INSTANCES BDRI
, BOM_RESOURCE_EQUIPMENTS BRE
, BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENTS BD1
WHERE BDRI.RESOURCE_ID = BRE.RESOURCE_ID
AND BDRI.INSTANCE_ID = BRE.INSTANCE_ID
AND BR.ORGANIZATION_ID = BRE.ORGANIZATION_ID
AND BR.RESOURCE_ID = BRE.RESOURCE_ID
AND DECODE(BDR.SHARE_FROM_DEPT_ID
, NULL
, BDR.DEPARTMENT_ID
, BDR.SHARE_FROM_DEPT_ID) = BDRI.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BRE.RESOURCE_ID
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND BD1.DEPARTMENT_ID(+) = BDR.SHARE_FROM_DEPT_ID UNION SELECT ROW_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, RESOURCE_ID
, RESOURCE_CODE
, DESCRIPTION
, INSTANCE_ID
, DEPARTMENT_ID
, DEPARTMENT_CODE
, SHARE_FROM_DEPT_ID
, SHARE_FROM_DEPT_CODE
, OWNING_DEPARTMENT_CODE
, CAPACITY_UNITS
, AVAILABLE_24_HOURS_FLAG
, RESOURCE_GROUP_NAME
, SHARE_CAPACITY_FLAG
, UNIT_OF_MEASURE
, AUTOCHARGE_TYPE
, CTP_FLAG
, SCHEDULE_TO_INSTANCE
FROM GMP_EAM_EQUIP_RESOURCES_V