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.

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_LABOUR_UTIL

Line 1469: -- insert records from MSC_INT_ASCP_LABOUR_UTIL

1465: END;
1466:
1467: BEGIN
1468: -- CODE GOES HERE
1469: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1470: INSERT INTO MSC_DEPARTMENT_RESOURCES (PLAN_ID,
1471: ORGANIZATION_ID,
1472: SR_INSTANCE_ID,
1473: RESOURCE_ID,

Line 1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,

1488: LAST_UPDATE_DATE,
1489: LAST_UPDATED_BY,
1490: CREATION_DATE,
1491: CREATED_BY)
1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

Line 1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,

1489: LAST_UPDATED_BY,
1490: CREATION_DATE,
1491: CREATED_BY)
1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1

Line 1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,

1490: CREATION_DATE,
1491: CREATED_BY)
1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1498: THEN NULL

Line 1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,

1491: CREATED_BY)
1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1498: THEN NULL
1499: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID

Line 1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

1492: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1498: THEN NULL
1499: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1500: END,--OWNING_DEPARTMENT_ID

Line 1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1

1493: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1494: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1498: THEN NULL
1499: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1500: END,--OWNING_DEPARTMENT_ID
1501: NULL, --CAPACITY_UNITS: nullable column, resource units

Line 1499: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID

1495: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1496: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1497: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1498: THEN NULL
1499: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1500: END,--OWNING_DEPARTMENT_ID
1501: NULL, --CAPACITY_UNITS: nullable column, resource units
1502: 2, -- RESOURCE_TYPE - it is a labour
1503: MSC_DEPARTMENT_RESOURCES.RESOURCE_CODE, --RESOURCE_CODE *

Line 1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON

1510: MSC_DEPARTMENT_RESOURCES.LINE_FLAG, --LINE_FLAG: 1 means line resource, 2 regular resource
1511: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1512: 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
1513: SYSDATE, '-1', SYSDATE, '-1'
1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

Line 1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1511: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1512: 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
1513: SYSDATE, '-1', SYSDATE, '-1'
1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;

Line 1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1512: 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
1513: SYSDATE, '-1', SYSDATE, '-1'
1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1520: EXCEPTION WHEN others THEN

Line 1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1513: SYSDATE, '-1', SYSDATE, '-1'
1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1520: EXCEPTION WHEN others THEN
1521: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;

Line 1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

1514: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1520: EXCEPTION WHEN others THEN
1521: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1522: raise;

Line 1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;

1515: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1516: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1520: EXCEPTION WHEN others THEN
1521: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1522: raise;
1523: END;

Line 1521: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;

1517: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1518: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1519: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1520: EXCEPTION WHEN others THEN
1521: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1522: raise;
1523: END;
1524:
1525:

Line 1629: -- insert records from MSC_INT_ASCP_LABOUR_UTIL

1625: END;
1626:
1627: BEGIN
1628: -- CODE GOES HERE
1629: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1630: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1631: ORGANIZATION_ID,
1632: SR_INSTANCE_ID,
1633: DEPARTMENT_ID,

Line 1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,

1640: UTILIZATION,
1641: RESOURCE_GROUP,
1642: OVERUTILIZATION_COST,
1643: RESOURCE_COST)
1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,

Line 1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

1641: RESOURCE_GROUP,
1642: OVERUTILIZATION_COST,
1643: RESOURCE_COST)
1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,

Line 1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,

1642: OVERUTILIZATION_COST,
1643: RESOURCE_COST)
1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,

Line 1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,

1643: RESOURCE_COST)
1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1651: -- There may be multiple instances of the same crew (same dept and res id). We do not want to

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

1644: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1651: -- There may be multiple instances of the same crew (same dept and res id). We do not want to
1652: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead

Line 1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,

1645: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1651: -- There may be multiple instances of the same crew (same dept and res id). We do not want to
1652: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1653: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).

Line 1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,

1646: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1647: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1648: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1649: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1651: -- There may be multiple instances of the same crew (same dept and res id). We do not want to
1652: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1653: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).
1654: MSC_INT_ASCP_LABOUR_UTIL.USED *

Line 1654: MSC_INT_ASCP_LABOUR_UTIL.USED *

1650: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1651: -- There may be multiple instances of the same crew (same dept and res id). We do not want to
1652: -- blindly get production cost from KPI table since it does not distinguish the instances. Instead
1653: -- we get corresponding cost of the resource (assume instances have same cost in the bucket).
1654: MSC_INT_ASCP_LABOUR_UTIL.USED *
1655: (
1656: select distinct MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCECOST
1657: from MSC_INT_ASCP_MFG_PLAN_LABOUR
1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND

Line 1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND

1654: MSC_INT_ASCP_LABOUR_UTIL.USED *
1655: (
1656: select distinct MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCECOST
1657: from MSC_INT_ASCP_MFG_PLAN_LABOUR
1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND
1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND

Line 1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND

1655: (
1656: select distinct MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCECOST
1657: from MSC_INT_ASCP_MFG_PLAN_LABOUR
1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND
1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND

Line 1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND

1656: select distinct MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCECOST
1657: from MSC_INT_ASCP_MFG_PLAN_LABOUR
1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND
1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )

Line 1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND

1657: from MSC_INT_ASCP_MFG_PLAN_LABOUR
1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND
1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES

Line 1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND

1658: where MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_MFG_PLAN_LABOUR.PLAN_ID AND
1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

Line 1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND

1659: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.INSTANCEID AND
1660: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_MFG_PLAN_LABOUR.ORGANIZATIONID AND
1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND

Line 1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES

1661: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_MFG_PLAN_LABOUR.DEPARTMENTID AND
1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

1662: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_MFG_PLAN_LABOUR.RESOURCEID AND
1663: MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_MFG_PLAN_LABOUR.PERIODEND
1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1664: )
1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:

Line 1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1665: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES
1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:
1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )

Line 1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1666: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:
1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )
1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

Line 1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;

1667: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1668: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1669: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:
1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )
1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

Line 1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

1670: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:
1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )
1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

1671: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID;
1672:
1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )
1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )
1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND

Line 1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1674: --FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND

Line 1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1675: --WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND

Line 1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND

1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND

Line 1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND

1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND

Line 1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND

1678: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);

Line 1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND

1679: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1687: EXCEPTION WHEN others THEN

Line 1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND

1680: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1687: EXCEPTION WHEN others THEN
1688: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;

Line 1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND

1681: --MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID = MSC_INT_ASCP_KPI.PLAN_ID (+) AND
1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1687: EXCEPTION WHEN others THEN
1688: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1689: raise;

Line 1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);

1682: --MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_INT_ASCP_KPI.INSTANCEID (+) AND
1683: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_INT_ASCP_KPI.ORGANIZATIONID (+) AND
1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1687: EXCEPTION WHEN others THEN
1688: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1689: raise;
1690: END;

Line 1688: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;

1684: --MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_INT_ASCP_KPI.ITEMID (+) AND
1685: --MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_INT_ASCP_KPI.DEPARTMENTID (+) AND
1686: --MSC_INT_ASCP_LABOUR_UTIL.PERIODEND = MSC_INT_ASCP_KPI.PERIODEND (+);
1687: EXCEPTION WHEN others THEN
1688: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002' || ' : ' || SQLERRM;
1689: raise;
1690: END;
1691:
1692: