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 1361: -- insert records from MSC_INT_ASCP_LABOUR_UTIL

1357: END;
1358:
1359: BEGIN
1360: -- CODE GOES HERE
1361: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1362: INSERT INTO MSC_DEPARTMENT_RESOURCES (PLAN_ID,
1363: ORGANIZATION_ID,
1364: SR_INSTANCE_ID,
1365: RESOURCE_ID,

Line 1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,

1380: LAST_UPDATE_DATE,
1381: LAST_UPDATED_BY,
1382: CREATION_DATE,
1383: CREATED_BY)
1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

Line 1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,

1381: LAST_UPDATED_BY,
1382: CREATION_DATE,
1383: CREATED_BY)
1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1

Line 1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,

1382: CREATION_DATE,
1383: CREATED_BY)
1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1390: THEN NULL

Line 1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,

1383: CREATED_BY)
1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1390: THEN NULL
1391: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID

Line 1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

1384: SELECT DISTINCT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID,
1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1390: THEN NULL
1391: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1392: END,--OWNING_DEPARTMENT_ID

Line 1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1

1385: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1386: MSC_INT_ASCP_LABOUR_UTIL.InstanceID,
1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1390: THEN NULL
1391: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1392: END,--OWNING_DEPARTMENT_ID
1393: NULL, --CAPACITY_UNITS: nullable column, resource units

Line 1391: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID

1387: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1388: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1389: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.ResourceID = -1
1390: THEN NULL
1391: ELSE MSC_INT_ASCP_LABOUR_UTIL.DepartmentID
1392: END,--OWNING_DEPARTMENT_ID
1393: NULL, --CAPACITY_UNITS: nullable column, resource units
1394: 2, -- RESOURCE_TYPE - it is a labour
1395: MSC_DEPARTMENT_RESOURCES.RESOURCE_CODE, --RESOURCE_CODE *

Line 1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON

1402: MSC_DEPARTMENT_RESOURCES.LINE_FLAG, --LINE_FLAG: 1 means line resource, 2 regular resource
1403: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1404: 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
1405: SYSDATE, '-1', SYSDATE, '-1'
1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

Line 1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1403: 1, --AGGREGATE_RESOURCE_FLAG: fill in with "1"
1404: 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
1405: SYSDATE, '-1', SYSDATE, '-1'
1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;

Line 1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1404: 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
1405: SYSDATE, '-1', SYSDATE, '-1'
1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1412: EXCEPTION WHEN others THEN

Line 1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1405: SYSDATE, '-1', SYSDATE, '-1'
1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1412: EXCEPTION WHEN others THEN
1413: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';

Line 1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID

1406: FROM MSC_INT_ASCP_LABOUR_UTIL LEFT JOIN MSC_DEPARTMENT_RESOURCES ON
1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1412: EXCEPTION WHEN others THEN
1413: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';
1414: raise;

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

1407: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1408: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1412: EXCEPTION WHEN others THEN
1413: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';
1414: raise;
1415: END;

Line 1413: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';

1409: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1410: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID
1411: WHERE MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar;
1412: EXCEPTION WHEN others THEN
1413: g_ErrorCode := 'ERROR_UPDATE_DEPARTMENT_RESOURCES_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';
1414: raise;
1415: END;
1416:
1417:

Line 1498: -- insert records from MSC_INT_ASCP_LABOUR_UTIL

1494: END;
1495:
1496: BEGIN
1497: -- CODE GOES HERE
1498: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1499: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1500: ORGANIZATION_ID,
1501: SR_INSTANCE_ID,
1502: DEPARTMENT_ID,

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

1509: UTILIZATION,
1510: RESOURCE_GROUP,
1511: OVERUTILIZATION_COST,
1512: RESOURCE_COST)
1513: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,

Line 1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,

1510: RESOURCE_GROUP,
1511: OVERUTILIZATION_COST,
1512: RESOURCE_COST)
1513: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,

Line 1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,

1511: OVERUTILIZATION_COST,
1512: RESOURCE_COST)
1513: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,

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

1512: RESOURCE_COST)
1513: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST

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

1513: SELECT MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID, MSC_INT_ASCP_LABOUR_UTIL.OrganizationID,
1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

Line 1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,

1514: MSC_INT_ASCP_LABOUR_UTIL.InstanceID, MSC_INT_ASCP_LABOUR_UTIL.DepartmentID,
1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

Line 1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,

1515: MSC_INT_ASCP_LABOUR_UTIL.ResourceID,
1516: CASE WHEN MSC_INT_ASCP_LABOUR_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND

Line 1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

1517: TO_DATE(MSC_INT_ASCP_LABOUR_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_LABOUR_UTIL.USED,
1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND

1518: MSC_INT_ASCP_LABOUR_UTIL.CAPACITY, MSC_INT_ASCP_LABOUR_UTIL.UTILIZATION,
1519: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_LABOUR_UTIL.OVERCOST,
1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1527: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1528: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND

Line 1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1521: FROM MSC_INT_ASCP_LABOUR_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1527: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1528: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1529: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

1522: WHERE MSC_INT_ASCP_LABOUR_UTIL.PLAN_ID=PlanIdVar AND
1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1527: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1528: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1529: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1530: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

Line 1527: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND

1523: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1525: MSC_INT_ASCP_LABOUR_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1526: MSC_INT_ASCP_LABOUR_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1527: MSC_INT_ASCP_LABOUR_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1528: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1529: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1530: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1531: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND

Line 1533: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_LABOUR_UTIL.PERIODEND;

1529: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1530: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1531: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1532: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1533: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_LABOUR_UTIL.PERIODEND;
1534: EXCEPTION WHEN others THEN
1535: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';
1536: raise;
1537: END;

Line 1535: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';

1531: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1532: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1533: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_LABOUR_UTIL.PERIODEND;
1534: EXCEPTION WHEN others THEN
1535: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_LABOUR_UTIL_001002';
1536: raise;
1537: END;
1538:
1539: