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.

[Home] [Help]

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_MACHINE_UTIL

Line 1411: -- insert records from MSC_INT_ASCP_MACHINE_UTIL

1407: END;
1408:
1409: BEGIN
1410: -- CODE GOES HERE
1411: -- insert records from MSC_INT_ASCP_MACHINE_UTIL
1412: INSERT INTO MSC_DEPARTMENT_RESOURCES (PLAN_ID,
1413: ORGANIZATION_ID,
1414: SR_INSTANCE_ID,
1415: RESOURCE_ID,

Line 1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,

1430: LAST_UPDATE_DATE,
1431: LAST_UPDATED_BY,
1432: CREATION_DATE,
1433: CREATED_BY)
1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,
1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,

Line 1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,

1431: LAST_UPDATED_BY,
1432: CREATION_DATE,
1433: CREATED_BY)
1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,
1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1

Line 1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,

1432: CREATION_DATE,
1433: CREATED_BY)
1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,
1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1
1440: THEN NULL

Line 1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,

1433: CREATED_BY)
1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,
1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1
1440: THEN NULL
1441: ELSE MSC_INT_ASCP_MACHINE_UTIL.DepartmentID

Line 1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,

1434: SELECT DISTINCT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID,
1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1
1440: THEN NULL
1441: ELSE MSC_INT_ASCP_MACHINE_UTIL.DepartmentID
1442: END,--OWNING_DEPARTMENT_ID

Line 1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1

1435: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1436: MSC_INT_ASCP_MACHINE_UTIL.InstanceID,
1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1
1440: THEN NULL
1441: ELSE MSC_INT_ASCP_MACHINE_UTIL.DepartmentID
1442: END,--OWNING_DEPARTMENT_ID
1443: NULL, --CAPACITY_UNITS: nullable column, resource units

Line 1441: ELSE MSC_INT_ASCP_MACHINE_UTIL.DepartmentID

1437: MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1438: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID,
1439: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.ResourceID = -1
1440: THEN NULL
1441: ELSE MSC_INT_ASCP_MACHINE_UTIL.DepartmentID
1442: END,--OWNING_DEPARTMENT_ID
1443: NULL, --CAPACITY_UNITS: nullable column, resource units
1444: 1, -- RESOURCE_TYPE it is a machine
1445: MSC_DEPARTMENT_RESOURCES.RESOURCE_CODE, --RESOURCE_CODE *

Line 1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON

1452: MSC_DEPARTMENT_RESOURCES.LINE_FLAG, --LINE_FLAG: 1 means line resource, 2 regular resource
1453: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1454: MSC_DEPARTMENT_RESOURCES.AVAILABLE_24_HOURS_FLAG, --Look up the table for the field using PLAN_ID=-1, ORG_ID, INST_ID and DEPT_ID
1455: SYSDATE, '-1', SYSDATE, '-1'
1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

Line 1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1453: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1454: MSC_DEPARTMENT_RESOURCES.AVAILABLE_24_HOURS_FLAG, --Look up the table for the field using PLAN_ID=-1, ORG_ID, INST_ID and DEPT_ID
1455: SYSDATE, '-1', SYSDATE, '-1'
1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;

Line 1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1454: MSC_DEPARTMENT_RESOURCES.AVAILABLE_24_HOURS_FLAG, --Look up the table for the field using PLAN_ID=-1, ORG_ID, INST_ID and DEPT_ID
1455: SYSDATE, '-1', SYSDATE, '-1'
1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;
1462: EXCEPTION WHEN others THEN

Line 1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1455: SYSDATE, '-1', SYSDATE, '-1'
1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;
1462: EXCEPTION WHEN others THEN
1463: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;

Line 1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

1456: FROM MSC_INT_ASCP_MACHINE_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;
1462: EXCEPTION WHEN others THEN
1463: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1464: raise;

Line 1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;

1457: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1458: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;
1462: EXCEPTION WHEN others THEN
1463: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1464: raise;
1465: END;

Line 1463: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;

1459: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1460: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1461: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar;
1462: EXCEPTION WHEN others THEN
1463: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1464: raise;
1465: END;
1466:
1467: BEGIN

Line 1565: -- insert records from MSC_INT_ASCP_MACHINE_UTIL

1561: END;
1562:
1563: BEGIN
1564: -- CODE GOES HERE
1565: -- insert records from MSC_INT_ASCP_MACHINE_UTIL
1566: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1567: ORGANIZATION_ID,
1568: SR_INSTANCE_ID,
1569: DEPARTMENT_ID,

Line 1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,

1576: UTILIZATION,
1577: RESOURCE_GROUP,
1578: OVERUTILIZATION_COST,
1579: RESOURCE_COST)
1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,

Line 1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,

1577: RESOURCE_GROUP,
1578: OVERUTILIZATION_COST,
1579: RESOURCE_COST)
1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,

Line 1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,

1578: OVERUTILIZATION_COST,
1579: RESOURCE_COST)
1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1586: -- There may be multiple instances of the same machine (same dept and res id). We do not want to

Line 1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,

1579: RESOURCE_COST)
1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1586: -- There may be multiple instances of the same machine (same dept and res id). We do not want to
1587: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead

Line 1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,

1580: SELECT MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID, MSC_INT_ASCP_MACHINE_UTIL.OrganizationID,
1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1586: -- There may be multiple instances of the same machine (same dept and res id). We do not want to
1587: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1588: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).

Line 1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,

1581: MSC_INT_ASCP_MACHINE_UTIL.InstanceID, MSC_INT_ASCP_MACHINE_UTIL.DepartmentID, MSC_INT_ASCP_MACHINE_UTIL.ResourceID,
1582: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1583: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1584: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1586: -- There may be multiple instances of the same machine (same dept and res id). We do not want to
1587: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1588: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).
1589: MSC_INT_ASCP_MACHINE_UTIL.USED *

Line 1589: MSC_INT_ASCP_MACHINE_UTIL.USED *

1585: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1586: -- There may be multiple instances of the same machine (same dept and res id). We do not want to
1587: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1588: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).
1589: MSC_INT_ASCP_MACHINE_UTIL.USED *
1590: (
1591: select distinct MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCECOST
1592: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND

Line 1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND

1589: MSC_INT_ASCP_MACHINE_UTIL.USED *
1590: (
1591: select distinct MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCECOST
1592: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND
1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND

Line 1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND

1590: (
1591: select distinct MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCECOST
1592: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND
1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND

Line 1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND

1591: select distinct MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCECOST
1592: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND
1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )

Line 1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND

1592: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND
1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES

Line 1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND

1593: where MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_MACHINE.PLAN_ID AND
1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND

Line 1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND

1594: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.INSTANCEID AND
1595: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_MACHINE.ORGANIZATIONID AND
1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND

Line 1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES

1596: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_MACHINE.DEPARTMENTID AND
1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND

1597: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_MACHINE.RESOURCEID AND
1598: MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_MACHINE.PERIODEND
1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1599: )
1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:

Line 1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1600: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES
1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:
1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)

Line 1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1601: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:
1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)
1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

Line 1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;

1602: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1603: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1604: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:
1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)
1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND

Line 1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

1605: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:
1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)
1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND

1606: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1607:
1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)
1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)
1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND

Line 1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND

Line 1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1610: --WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND

Line 1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND

1611: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category

Line 1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND

1612: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export

Line 1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND

1613: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);

Line 1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND

1614: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1622: EXCEPTION WHEN others THEN

Line 1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category

1615: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1622: EXCEPTION WHEN others THEN
1623: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;

Line 1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export

1616: --MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1622: EXCEPTION WHEN others THEN
1623: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1624: raise;

Line 1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);

1617: --MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1618: --MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1622: EXCEPTION WHEN others THEN
1623: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1624: raise;
1625: END;

Line 1623: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;

1619: --MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND -- the dept and item are toggled due to lack of category
1620: --MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND -- toggled dept and resource id because in KPI export
1621: --MSC_INT_ASCP_MACHINE_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1622: EXCEPTION WHEN others THEN
1623: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001' || ' : ' || SQLERRM;
1624: raise;
1625: END;
1626:
1627: BEGIN