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_KPI

Line 1449: select DISTINCT ScenarioName into ScenarioNameVar from MSC_INT_ASCP_KPI where PLAN_ID=PlanIdVar;

1445: NULL; -- do nothing
1446: END;
1447:
1448: BEGIN
1449: select DISTINCT ScenarioName into ScenarioNameVar from MSC_INT_ASCP_KPI where PLAN_ID=PlanIdVar;
1450: EXCEPTION WHEN others THEN
1451: ScenarioNameVar := '';
1452: END;
1453:

Line 1477: MSC_INT_ASCP_KPI.PRODUCTIONCOST

1473: CASE WHEN MSC_INT_ASCP_MACHINE_UTIL.DETAIL_LEVEL='Week' THEN '1' ELSE NULL END, 1,
1474: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1475: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1476: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1477: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1478: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1479: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1480: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1481: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

Line 1478: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

1474: TO_DATE(MSC_INT_ASCP_MACHINE_UTIL.PERIODEND,'YYYY-MM-DD')-1/86400, MSC_INT_ASCP_MACHINE_UTIL.USED,
1475: MSC_INT_ASCP_MACHINE_UTIL.CAPACITY, MSC_INT_ASCP_MACHINE_UTIL.UTILIZATION,
1476: MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME, MSC_INT_ASCP_MACHINE_UTIL.OVERCOST,
1477: MSC_INT_ASCP_KPI.PRODUCTIONCOST
1478: FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI
1479: WHERE MSC_INT_ASCP_MACHINE_UTIL.PLAN_ID=PlanIdVar AND
1480: MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1481: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1482: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

Line 1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND

1481: MSC_INT_ASCP_MACHINE_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1482: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1483: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1484: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category

Line 1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND

1482: MSC_INT_ASCP_MACHINE_UTIL.InstanceID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1483: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1484: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category
1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;

Line 1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND

1483: MSC_INT_ASCP_MACHINE_UTIL.DepartmentID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND
1484: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category
1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;
1491: EXCEPTION WHEN others THEN

Line 1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export

1484: MSC_INT_ASCP_MACHINE_UTIL.ResourceID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category
1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;
1491: EXCEPTION WHEN others THEN
1492: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001';

Line 1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category

1485: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar AND
1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category
1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;
1491: EXCEPTION WHEN others THEN
1492: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001';
1493: raise;

Line 1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;

1486: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID AND
1487: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID AND
1488: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND -- toggled dept and resource id because in KPI export
1489: MSC_INT_ASCP_KPI.ITEMID = MSC_DEPARTMENT_RESOURCES.DEPARTMENT_ID AND -- the dept and item are toggled due to lack of category
1490: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_MACHINE_UTIL.PERIODEND;
1491: EXCEPTION WHEN others THEN
1492: g_ErrorCode := 'ERROR_UPDATE_RES_SUMMARY_FROM_MSC_INT_ASCP_MACHINE_UTIL_001001';
1493: raise;
1494: END;

Line 1520: MSC_INT_ASCP_KPI.PRODUCTIONCOST

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
1524: MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID 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 1528: MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar 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
1532: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND

Line 1529: MSC_INT_ASCP_KPI.INSTANCEID = MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_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
1532: MSC_INT_ASCP_KPI.DEPARTMENTID = MSC_DEPARTMENT_RESOURCES.RESOURCE_ID AND
1533: MSC_INT_ASCP_KPI.PERIODEND = MSC_INT_ASCP_LABOUR_UTIL.PERIODEND;

Line 1530: MSC_INT_ASCP_KPI.ORGANIZATIONID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_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
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

Line 1531: MSC_INT_ASCP_KPI.ITEMID = 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
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';

Line 1532: MSC_INT_ASCP_KPI.DEPARTMENTID = 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
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;

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 1641: FROM msc_int_ascp_prodcost_kpi, MSC_INT_ASCP_KPI

1637: SELECT msc_int_ascp_prodcost_kpi.plan_id,
1638: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1639: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,
1640: SUM(msc_int_ascp_prodcost_kpi.prodCost)
1641: FROM msc_int_ascp_prodcost_kpi, MSC_INT_ASCP_KPI
1642: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND
1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:

Line 1642: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND

1638: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1639: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,
1640: SUM(msc_int_ascp_prodcost_kpi.prodCost)
1641: FROM msc_int_ascp_prodcost_kpi, MSC_INT_ASCP_KPI
1642: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND
1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND

Line 1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND

1639: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,
1640: SUM(msc_int_ascp_prodcost_kpi.prodCost)
1641: FROM msc_int_ascp_prodcost_kpi, MSC_INT_ASCP_KPI
1642: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND
1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND

Line 1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1642: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND
1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1649: msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1650: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,

Line 1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND

1643: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null AND
1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1649: msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1650: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1651: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

Line 1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND

1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND
1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1649: msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1650: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1651: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1652: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;

Line 1649: msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID

1645:
1646: msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1647: msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1649: msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1650: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1651: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1652: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;
1653: EXCEPTION WHEN others THEN

Line 1668: FROM msc_int_ascp_kpi

1664: periodEnd,
1665: transpCost )
1666: SELECT DISTINCT plan_id, organizationID, instanceID, itemID, periodEnd, sum
1667: (transportationcost)
1668: FROM msc_int_ascp_kpi
1669: WHERE plan_id=PlanIdVar and transportationmode is not null
1670: GROUP BY plan_id, organizationID, instanceID, itemID, periodEnd;
1671: EXCEPTION WHEN others THEN
1672: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001007';

Line 1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,

1706: CREATED_BY)
1707: --------------------------------
1708: -- Supplier-denpendent records
1709: --------------------------------
1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1711: MSC_INT_ASCP_KPI.OrganizationID,
1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,

Line 1711: MSC_INT_ASCP_KPI.OrganizationID,

1707: --------------------------------
1708: -- Supplier-denpendent records
1709: --------------------------------
1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1711: MSC_INT_ASCP_KPI.OrganizationID,
1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,
1715: 1,

Line 1712: MSC_INT_ASCP_KPI.InstanceID,

1708: -- Supplier-denpendent records
1709: --------------------------------
1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1711: MSC_INT_ASCP_KPI.OrganizationID,
1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,
1715: 1,
1716: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,

Line 1713: MSC_INT_ASCP_KPI.ItemID,

1709: --------------------------------
1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1711: MSC_INT_ASCP_KPI.OrganizationID,
1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,
1715: 1,
1716: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1717: 0, --TO_NUMBER(NULL) MDS_PRICE,

Line 1714: MSC_INT_ASCP_KPI.PeriodType,

1710: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1711: MSC_INT_ASCP_KPI.OrganizationID,
1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,
1715: 1,
1716: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1717: 0, --TO_NUMBER(NULL) MDS_PRICE,
1718: TO_NUMBER(NULL), -- ZONEID,

Line 1716: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,

1712: MSC_INT_ASCP_KPI.InstanceID,
1713: MSC_INT_ASCP_KPI.ItemID,
1714: MSC_INT_ASCP_KPI.PeriodType,
1715: 1,
1716: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1717: 0, --TO_NUMBER(NULL) MDS_PRICE,
1718: TO_NUMBER(NULL), -- ZONEID,
1719: 0, --TO_NUMBER(NULL) PRODUCTION_COST,
1720: -- supplier related column: purchase cost

Line 1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY

1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND

1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND

Line 1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;

Line 1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND

1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN

Line 1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN
1748: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008';

Line 1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND

1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN
1748: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008';
1749: raise;

Line 1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;

1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN
1748: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008';
1749: raise;
1750: END;

Line 1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,

1780: LAST_UPDATE_DATE,
1781: LAST_UPDATED_BY,
1782: CREATION_DATE,
1783: CREATED_BY)
1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1785: MSC_INT_ASCP_KPI.OrganizationID,
1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,

Line 1785: MSC_INT_ASCP_KPI.OrganizationID,

1781: LAST_UPDATED_BY,
1782: CREATION_DATE,
1783: CREATED_BY)
1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1785: MSC_INT_ASCP_KPI.OrganizationID,
1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,

Line 1786: MSC_INT_ASCP_KPI.InstanceID,

1782: CREATION_DATE,
1783: CREATED_BY)
1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1785: MSC_INT_ASCP_KPI.OrganizationID,
1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,

Line 1787: MSC_INT_ASCP_KPI.ItemID,

1783: CREATED_BY)
1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1785: MSC_INT_ASCP_KPI.OrganizationID,
1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost

Line 1788: MSC_INT_ASCP_KPI.PeriodType,

1784: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
1785: MSC_INT_ASCP_KPI.OrganizationID,
1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost
1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

Line 1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,

1786: MSC_INT_ASCP_KPI.InstanceID,
1787: MSC_INT_ASCP_KPI.ItemID,
1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost
1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,
1794: MSC_INT_ASCP_KPI.ZoneID,

Line 1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

1788: MSC_INT_ASCP_KPI.PeriodType,
1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost
1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,
1794: MSC_INT_ASCP_KPI.ZoneID,
1795: -- production_cost
1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null

Line 1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,

1789: 1,
1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost
1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,
1794: MSC_INT_ASCP_KPI.ZoneID,
1795: -- production_cost
1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1797: then (

Line 1794: MSC_INT_ASCP_KPI.ZoneID,

1790: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1791: -- demand cost
1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,
1794: MSC_INT_ASCP_KPI.ZoneID,
1795: -- production_cost
1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1797: then (
1798: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

Line 1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null

1792: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1793: MSC_INT_ASCP_KPI.DemandCost else 0 end,
1794: MSC_INT_ASCP_KPI.ZoneID,
1795: -- production_cost
1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1797: then (
1798: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
1799: WHERE PLAN_ID=PlanIdVar AND
1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

Line 1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

1796: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1797: then (
1798: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
1799: WHERE PLAN_ID=PlanIdVar AND
1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1801: AND
1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1803: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1804: InstanceID=MSC_INT_ASCP_KPI.InstanceID

Line 1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1798: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
1799: WHERE PLAN_ID=PlanIdVar AND
1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1801: AND
1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1803: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1804: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1805: )=0 then 0
1806: else (SELECT DISTINCT totalProdCost FROM

Line 1803: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1799: WHERE PLAN_ID=PlanIdVar AND
1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1801: AND
1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1803: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1804: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1805: )=0 then 0
1806: else (SELECT DISTINCT totalProdCost FROM
1807: msc_int_ascp_totalprodcost

Line 1804: InstanceID=MSC_INT_ASCP_KPI.InstanceID

1800: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1801: AND
1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1803: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1804: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1805: )=0 then 0
1806: else (SELECT DISTINCT totalProdCost FROM
1807: msc_int_ascp_totalprodcost
1808: WHERE PLAN_ID=PlanIdVar AND

Line 1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1805: )=0 then 0
1806: else (SELECT DISTINCT totalProdCost FROM
1807: msc_int_ascp_totalprodcost
1808: WHERE PLAN_ID=PlanIdVar AND
1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1812: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1813: end)

Line 1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1806: else (SELECT DISTINCT totalProdCost FROM
1807: msc_int_ascp_totalprodcost
1808: WHERE PLAN_ID=PlanIdVar AND
1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1812: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1813: end)
1814: else 0 end,

Line 1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1807: msc_int_ascp_totalprodcost
1808: WHERE PLAN_ID=PlanIdVar AND
1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1812: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1813: end)
1814: else 0 end,
1815: -- supplier related column: purchase cost

Line 1812: InstanceID=MSC_INT_ASCP_KPI.InstanceID)

1808: WHERE PLAN_ID=PlanIdVar AND
1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1812: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1813: end)
1814: else 0 end,
1815: -- supplier related column: purchase cost
1816: 0, --TO_NUMBER(NULL) PURCHASING_COST,

Line 1818: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

1814: else 0 end,
1815: -- supplier related column: purchase cost
1816: 0, --TO_NUMBER(NULL) PURCHASING_COST,
1817: -- carrying cost
1818: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1819: MSC_INT_ASCP_KPI.InventoryCost else 0 end,
1820: -- transportastion cost
1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,

Line 1819: MSC_INT_ASCP_KPI.InventoryCost else 0 end,

1815: -- supplier related column: purchase cost
1816: 0, --TO_NUMBER(NULL) PURCHASING_COST,
1817: -- carrying cost
1818: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1819: MSC_INT_ASCP_KPI.InventoryCost else 0 end,
1820: -- transportastion cost
1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,
1823: -- other cost

Line 1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0

1817: -- carrying cost
1818: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1819: MSC_INT_ASCP_KPI.InventoryCost else 0 end,
1820: -- transportastion cost
1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,
1823: -- other cost
1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,

Line 1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,

1818: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1819: MSC_INT_ASCP_KPI.InventoryCost else 0 end,
1820: -- transportastion cost
1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,
1823: -- other cost
1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,
1826: -- PAB

Line 1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

1820: -- transportastion cost
1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,
1823: -- other cost
1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,
1826: -- PAB
1827: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1828: then (

Line 1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,

1821: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then 0
1822: else MSC_INT_ASCP_KPI.TRANSPORTATIONCOST end,
1823: -- other cost
1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,
1826: -- PAB
1827: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1828: then (
1829: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY

Line 1827: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null

1823: -- other cost
1824: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1825: MSC_INT_ASCP_KPI.OtherCost else 0 end,
1826: -- PAB
1827: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1828: then (
1829: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
1830: WHERE PLAN_ID=PlanIdVar AND
1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

Line 1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

1827: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null
1828: then (
1829: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
1830: WHERE PLAN_ID=PlanIdVar AND
1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1832: AND
1833: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1834: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1835: InstanceID=MSC_INT_ASCP_KPI.InstanceID

Line 1833: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1829: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
1830: WHERE PLAN_ID=PlanIdVar AND
1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1832: AND
1833: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1834: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1835: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1836: )=0 then 0
1837: else (SELECT DISTINCT StorageAmount FROM MSC_INT_ASCP_INVENTORY

Line 1834: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1830: WHERE PLAN_ID=PlanIdVar AND
1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1832: AND
1833: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1834: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1835: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1836: )=0 then 0
1837: else (SELECT DISTINCT StorageAmount FROM MSC_INT_ASCP_INVENTORY
1838: WHERE

Line 1835: InstanceID=MSC_INT_ASCP_KPI.InstanceID

1831: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1832: AND
1833: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1834: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1835: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1836: )=0 then 0
1837: else (SELECT DISTINCT StorageAmount FROM MSC_INT_ASCP_INVENTORY
1838: WHERE
1839: PLAN_ID=PlanIdVar AND

Line 1840: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1836: )=0 then 0
1837: else (SELECT DISTINCT StorageAmount FROM MSC_INT_ASCP_INVENTORY
1838: WHERE
1839: PLAN_ID=PlanIdVar AND
1840: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1841: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1842: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1843: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
1844: end)

Line 1841: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1837: else (SELECT DISTINCT StorageAmount FROM MSC_INT_ASCP_INVENTORY
1838: WHERE
1839: PLAN_ID=PlanIdVar AND
1840: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1841: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1842: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1843: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
1844: end)
1845: else

Line 1842: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1838: WHERE
1839: PLAN_ID=PlanIdVar AND
1840: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1841: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1842: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1843: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
1844: end)
1845: else
1846: 0

Line 1843: InstanceID=MSC_INT_ASCP_KPI.InstanceID )

1839: PLAN_ID=PlanIdVar AND
1840: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1841: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1842: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1843: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
1844: end)
1845: else
1846: 0
1847: end,

Line 1849: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

1845: else
1846: 0
1847: end,
1848: -- total cost
1849: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1850: -- add demand cost
1851: case when MSC_INT_ASCP_KPI.DEMANDCOST > 0 then
1852: MSC_INT_ASCP_KPI.DEMANDCOST
1853: else 0 end +

Line 1851: case when MSC_INT_ASCP_KPI.DEMANDCOST > 0 then

1847: end,
1848: -- total cost
1849: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1850: -- add demand cost
1851: case when MSC_INT_ASCP_KPI.DEMANDCOST > 0 then
1852: MSC_INT_ASCP_KPI.DEMANDCOST
1853: else 0 end +
1854: -- purchasing cost is by supplier, not added here
1855: -- production cost

Line 1852: MSC_INT_ASCP_KPI.DEMANDCOST

1848: -- total cost
1849: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1850: -- add demand cost
1851: case when MSC_INT_ASCP_KPI.DEMANDCOST > 0 then
1852: MSC_INT_ASCP_KPI.DEMANDCOST
1853: else 0 end +
1854: -- purchasing cost is by supplier, not added here
1855: -- production cost
1856: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

Line 1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

1854: -- purchasing cost is by supplier, not added here
1855: -- production cost
1856: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
1857: WHERE PLAN_ID=PlanIdVar AND
1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1859: AND
1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1861: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1862: InstanceID=MSC_INT_ASCP_KPI.InstanceID

Line 1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1856: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
1857: WHERE PLAN_ID=PlanIdVar AND
1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1859: AND
1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1861: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1862: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1863: )=0 then 0
1864: else (SELECT DISTINCT totalProdCost FROM

Line 1861: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1857: WHERE PLAN_ID=PlanIdVar AND
1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1859: AND
1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1861: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1862: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1863: )=0 then 0
1864: else (SELECT DISTINCT totalProdCost FROM
1865: msc_int_ascp_totalprodcost

Line 1862: InstanceID=MSC_INT_ASCP_KPI.InstanceID

1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1859: AND
1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1861: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1862: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1863: )=0 then 0
1864: else (SELECT DISTINCT totalProdCost FROM
1865: msc_int_ascp_totalprodcost
1866: WHERE PLAN_ID=PlanIdVar AND

Line 1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1863: )=0 then 0
1864: else (SELECT DISTINCT totalProdCost FROM
1865: msc_int_ascp_totalprodcost
1866: WHERE PLAN_ID=PlanIdVar AND
1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1870: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1871: end +

Line 1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1864: else (SELECT DISTINCT totalProdCost FROM
1865: msc_int_ascp_totalprodcost
1866: WHERE PLAN_ID=PlanIdVar AND
1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1870: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1871: end +
1872: -- transportation cost

Line 1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1865: msc_int_ascp_totalprodcost
1866: WHERE PLAN_ID=PlanIdVar AND
1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1870: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1871: end +
1872: -- transportation cost
1873: case when (SELECT COUNT(*) FROM msc_int_ascp_transpcost_kpi

Line 1870: InstanceID=MSC_INT_ASCP_KPI.InstanceID)

1866: WHERE PLAN_ID=PlanIdVar AND
1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1870: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1871: end +
1872: -- transportation cost
1873: case when (SELECT COUNT(*) FROM msc_int_ascp_transpcost_kpi
1874: WHERE PLAN_ID=PlanIdVar AND

Line 1875: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID

1871: end +
1872: -- transportation cost
1873: case when (SELECT COUNT(*) FROM msc_int_ascp_transpcost_kpi
1874: WHERE PLAN_ID=PlanIdVar AND
1875: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1876: AND
1877: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1878: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1879: InstanceID=MSC_INT_ASCP_KPI.InstanceID

Line 1877: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1873: case when (SELECT COUNT(*) FROM msc_int_ascp_transpcost_kpi
1874: WHERE PLAN_ID=PlanIdVar AND
1875: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1876: AND
1877: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1878: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1879: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1880: )=0 then 0
1881: else (SELECT DISTINCT TRANSPCOST FROM

Line 1878: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1874: WHERE PLAN_ID=PlanIdVar AND
1875: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1876: AND
1877: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1878: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1879: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1880: )=0 then 0
1881: else (SELECT DISTINCT TRANSPCOST FROM
1882: msc_int_ascp_transpcost_kpi

Line 1879: InstanceID=MSC_INT_ASCP_KPI.InstanceID

1875: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1876: AND
1877: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1878: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1879: InstanceID=MSC_INT_ASCP_KPI.InstanceID
1880: )=0 then 0
1881: else (SELECT DISTINCT TRANSPCOST FROM
1882: msc_int_ascp_transpcost_kpi
1883: WHERE PLAN_ID=PlanIdVar AND

Line 1884: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1880: )=0 then 0
1881: else (SELECT DISTINCT TRANSPCOST FROM
1882: msc_int_ascp_transpcost_kpi
1883: WHERE PLAN_ID=PlanIdVar AND
1884: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +

Line 1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND

1881: else (SELECT DISTINCT TRANSPCOST FROM
1882: msc_int_ascp_transpcost_kpi
1883: WHERE PLAN_ID=PlanIdVar AND
1884: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +

Line 1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1882: msc_int_ascp_transpcost_kpi
1883: WHERE PLAN_ID=PlanIdVar AND
1884: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST

Line 1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)

1883: WHERE PLAN_ID=PlanIdVar AND
1884: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST
1891: else 0 end,

Line 1889: MSC_INT_ASCP_KPI.INVENTORYCOST +

1885: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST
1891: else 0 end,
1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1893: MSC_INT_ASCP_KPI.DemandFillRate

Line 1890: MSC_INT_ASCP_KPI.OTHERCOST

1886: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1887: InstanceID=MSC_INT_ASCP_KPI.InstanceID)
1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST
1891: else 0 end,
1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1893: MSC_INT_ASCP_KPI.DemandFillRate
1894: else 0 end,

Line 1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then

1888: end +
1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST
1891: else 0 end,
1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1893: MSC_INT_ASCP_KPI.DemandFillRate
1894: else 0 end,
1895: 1,
1896: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE,

Line 1893: MSC_INT_ASCP_KPI.DemandFillRate

1889: MSC_INT_ASCP_KPI.INVENTORYCOST +
1890: MSC_INT_ASCP_KPI.OTHERCOST
1891: else 0 end,
1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1893: MSC_INT_ASCP_KPI.DemandFillRate
1894: else 0 end,
1895: 1,
1896: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE,
1897: -- supplier related columns

Line 1896: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE,

1892: case when MSC_INT_ASCP_KPI.TRANSPORTATIONMODE is null then
1893: MSC_INT_ASCP_KPI.DemandFillRate
1894: else 0 end,
1895: 1,
1896: MSC_INT_ASCP_KPI.TRANSPORTATIONMODE,
1897: -- supplier related columns
1898: TO_NUMBER(NULL), --SUPPLIER_ID,
1899: TO_NUMBER(NULL), --SUPPLIER_SITE_ID,
1900: 0,-- TO_NUMBER(NULL) SUPPLIER_USAGE,

Line 1905: FROM MSC_INT_ASCP_KPI

1901: 0,-- TO_NUMBER(NULL) SUPPLIER_CAPACITY,
1902: 0,
1903: 0,
1904: SYSDATE, '-1', SYSDATE, '-1'
1905: FROM MSC_INT_ASCP_KPI
1906: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1907: EXCEPTION WHEN others THEN
1908: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001009';
1909: raise;

Line 1906: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;

1902: 0,
1903: 0,
1904: SYSDATE, '-1', SYSDATE, '-1'
1905: FROM MSC_INT_ASCP_KPI
1906: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1907: EXCEPTION WHEN others THEN
1908: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001009';
1909: raise;
1910: