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 1558: select DISTINCT ScenarioName into ScenarioNameVar from MSC_INT_ASCP_KPI where PLAN_ID=PlanIdVar;

1554: NULL; -- do nothing
1555: END;
1556:
1557: BEGIN
1558: select DISTINCT ScenarioName into ScenarioNameVar from MSC_INT_ASCP_KPI where PLAN_ID=PlanIdVar;
1559: EXCEPTION WHEN others THEN
1560: ScenarioNameVar := '';
1561: END;
1562:

Line 1608: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0)

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

Line 1609: --FROM MSC_INT_ASCP_MACHINE_UTIL, MSC_DEPARTMENT_RESOURCES, MSC_INT_ASCP_KPI

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1673: --NVL(MSC_INT_ASCP_KPI.PRODUCTIONCOST, 0 )

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
1676: --MSC_DEPARTMENT_RESOURCES.PLAN_ID=-1 AND
1677: --MSC_INT_ASCP_LABOUR_UTIL.OrganizationID = MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID 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 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 1779: -- Due to reansporation cost being mvoed out of msc_int_ascp_kpi, the table

1775:
1776: BEGIN
1777: -- CODE GOES HERE
1778: -- fill in data from msc_int_ascp_prodcost_kpi
1779: -- Due to reansporation cost being mvoed out of msc_int_ascp_kpi, the table
1780: -- no longer has corresponding org-item records for heere to compare. But the
1781: -- records are already unique so we directly sum them up.
1782: INSERT INTO msc_int_ascp_totalprodcost ( plan_id,
1783: organizationID,

Line 1793: --, MSC_INT_ASCP_KPI

1789: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1790: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,
1791: SUM(msc_int_ascp_prodcost_kpi.prodCost)
1792: FROM msc_int_ascp_prodcost_kpi
1793: --, MSC_INT_ASCP_KPI
1794: WHERE
1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND

Line 1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND

1791: SUM(msc_int_ascp_prodcost_kpi.prodCost)
1792: FROM msc_int_ascp_prodcost_kpi
1793: --, MSC_INT_ASCP_KPI
1794: WHERE
1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND

Line 1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1793: --, MSC_INT_ASCP_KPI
1794: WHERE
1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1801: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,

Line 1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND

1794: WHERE
1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1801: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1802: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

Line 1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND

1795: --MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar AND
1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1801: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1802: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1803: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;

Line 1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID

1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND
1797: --msc_int_ascp_prodcost_kpi.organizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1798: --msc_int_ascp_prodcost_kpi.itemID=MSC_INT_ASCP_KPI.ItemID AND
1799: --msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND AND
1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID
1801: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,
1802: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,
1803: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;
1804: EXCEPTION WHEN others THEN

Line 1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )

1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,
1853: MSC_INT_ASCP_SUPPLY.OrganizationID,
1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
1857: 1,
1858: TO_DATE( MSC_INT_ASCP_SUPPLY.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1859: 0, --TO_NUMBER(NULL) MDS_PRICE,
1860: -23453, -- ZONEID,

Line 1927: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Transportation report, -- DETAIL_LEVEL ( BUGBUG does not accept FIRST )

1923: -- case when MSC_INT_ASCP_TRANSPORTATION.SUBCATEGORY='Customer' THEN -23453 else MSC_INT_ASCP_TRANSPORTATION.ToInstanceID end,
1924: case when MSC_INT_ASCP_TRANSPORTATION.SUBCATEGORY='Customer' THEN MSC_INT_ASCP_TRANSPORTATION.FromOrgID else MSC_INT_ASCP_TRANSPORTATION.ToOrgID end,
1925: case when MSC_INT_ASCP_TRANSPORTATION.SUBCATEGORY='Customer' THEN MSC_INT_ASCP_TRANSPORTATION.FromInstanceID else MSC_INT_ASCP_TRANSPORTATION.ToInstanceID end,
1926: MSC_INT_ASCP_TRANSPORTATION.ItemID,
1927: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Transportation report, -- DETAIL_LEVEL ( BUGBUG does not accept FIRST )
1928: 1, --PERIOD_TYPE
1929: TO_DATE( MSC_INT_ASCP_TRANSPORTATION.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1930: MSC_INT_ASCP_TRANSPORTATION.TransportMode,
1931: MSC_INT_ASCP_TRANSPORTATION.Cost * MSC_INT_ASCP_TRANSPORTATION.Quantity,

Line 2065: SELECT MSC_INT_ASCP_KPI.PLAN_ID,

2061: LAST_UPDATE_DATE,
2062: LAST_UPDATED_BY,
2063: CREATION_DATE,
2064: CREATED_BY)
2065: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
2066: -- Next 2 lines are changed to accomodate the S&OP request to populate dest org with source org when shipping to a customer:
2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,

Line 2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,

2063: CREATION_DATE,
2064: CREATED_BY)
2065: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
2066: -- Next 2 lines are changed to accomodate the S&OP request to populate dest org with source org when shipping to a customer:
2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,

Line 2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,

2064: CREATED_BY)
2065: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
2066: -- Next 2 lines are changed to accomodate the S&OP request to populate dest org with source org when shipping to a customer:
2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,

Line 2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,

2065: SELECT MSC_INT_ASCP_KPI.PLAN_ID,
2066: -- Next 2 lines are changed to accomodate the S&OP request to populate dest org with source org when shipping to a customer:
2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,

Line 2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,

2066: -- Next 2 lines are changed to accomodate the S&OP request to populate dest org with source org when shipping to a customer:
2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,

Line 2071: MSC_INT_ASCP_KPI.ItemID,

2067: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else MSC_INT_ASCP_KPI.OrganizationID end,
2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost

Line 2072: MSC_INT_ASCP_KPI.PeriodType,

2068: -- case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else MSC_INT_ASCP_KPI.InstanceID end,
2069: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND OrganizationID = -23453 THEN Source_Organization_ID ELSE OrganizationID END,
2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,

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

2070: case when MSC_INT_ASCP_KPI.DemandCost<>0 AND InstanceID = -23453 THEN Source_Org_Instance_ID ELSE InstanceID END,
2071: MSC_INT_ASCP_KPI.ItemID,
2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,

Line 2076: MSC_INT_ASCP_KPI.DemandCost,

2072: MSC_INT_ASCP_KPI.PeriodType,
2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,

Line 2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,

2073: 1,
2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,
2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,

Line 2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,

2074: TO_DATE( MSC_INT_ASCP_KPI.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,
2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,
2082:

Line 2079: MSC_INT_ASCP_KPI.ZoneID,

2075: -- demand cost
2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,
2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,
2082:
2083: -- production_cost: added as separate records

Line 2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,

2076: MSC_INT_ASCP_KPI.DemandCost,
2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,
2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,
2082:
2083: -- production_cost: added as separate records
2084: 0,

Line 2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,

2077: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Org_Instance_ID else -23453 end, -- SOURCE_ORG_INSTANCE_ID,
2078: case when MSC_INT_ASCP_KPI.DemandCost<>0 then Source_Organization_ID else -23453 end, -- SOURCE_ORGANIZATION_ID,
2079: MSC_INT_ASCP_KPI.ZoneID,
2080: MSC_INT_ASCP_KPI.Customer_Site_ID, --CUSTOMER_SITE_ID,
2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,
2082:
2083: -- production_cost: added as separate records
2084: 0,
2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

Line 2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

2083: -- production_cost: added as separate records
2084: 0,
2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
2086: -- WHERE PLAN_ID=PlanIdVar AND
2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID
2091: -- )=0 then 0

Line 2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND

2084: 0,
2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
2086: -- WHERE PLAN_ID=PlanIdVar AND
2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID
2091: -- )=0 then 0
2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )

Line 2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
2086: -- WHERE PLAN_ID=PlanIdVar AND
2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID
2091: -- )=0 then 0
2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )
2093: -- msc_int_ascp_totalprodcost

Line 2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID

2086: -- WHERE PLAN_ID=PlanIdVar AND
2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID
2091: -- )=0 then 0
2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )
2093: -- msc_int_ascp_totalprodcost
2094: -- WHERE PLAN_ID=PlanIdVar AND

Line 2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

2091: -- )=0 then 0
2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )
2093: -- msc_int_ascp_totalprodcost
2094: -- WHERE PLAN_ID=PlanIdVar AND
2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)
2099: --end,

Line 2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND

2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )
2093: -- msc_int_ascp_totalprodcost
2094: -- WHERE PLAN_ID=PlanIdVar AND
2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)
2099: --end,
2100:

Line 2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

2093: -- msc_int_ascp_totalprodcost
2094: -- WHERE PLAN_ID=PlanIdVar AND
2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)
2099: --end,
2100:
2101: -- carrying cost

Line 2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)

2094: -- WHERE PLAN_ID=PlanIdVar AND
2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)
2099: --end,
2100:
2101: -- carrying cost
2102: MSC_INT_ASCP_KPI.InventoryCost,

Line 2102: MSC_INT_ASCP_KPI.InventoryCost,

2098: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID)
2099: --end,
2100:
2101: -- carrying cost
2102: MSC_INT_ASCP_KPI.InventoryCost,
2103:
2104: -- other cost
2105: MSC_INT_ASCP_KPI.OtherCost,
2106: -- PAB

Line 2105: MSC_INT_ASCP_KPI.OtherCost,

2101: -- carrying cost
2102: MSC_INT_ASCP_KPI.InventoryCost,
2103:
2104: -- other cost
2105: MSC_INT_ASCP_KPI.OtherCost,
2106: -- PAB
2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

Line 2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

2105: MSC_INT_ASCP_KPI.OtherCost,
2106: -- PAB
2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID
2113: )=0 then 0

Line 2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND

2106: -- PAB
2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID
2113: )=0 then 0
2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )

Line 2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID
2113: )=0 then 0
2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )
2115: WHERE

Line 2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID

2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID
2113: )=0 then 0
2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )
2115: WHERE
2116: PLAN_ID=PlanIdVar AND

Line 2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

2113: )=0 then 0
2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )
2115: WHERE
2116: PLAN_ID=PlanIdVar AND
2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
2121: end,

Line 2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND

2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )
2115: WHERE
2116: PLAN_ID=PlanIdVar AND
2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
2121: end,
2122: MSC_INT_ASCP_KPI.DemandFillRate,

Line 2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

2115: WHERE
2116: PLAN_ID=PlanIdVar AND
2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
2121: end,
2122: MSC_INT_ASCP_KPI.DemandFillRate,
2123: 1,

Line 2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )

2116: PLAN_ID=PlanIdVar AND
2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
2121: end,
2122: MSC_INT_ASCP_KPI.DemandFillRate,
2123: 1,
2124: -- supplier related columns

Line 2122: MSC_INT_ASCP_KPI.DemandFillRate,

2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2119: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2120: InstanceID=MSC_INT_ASCP_KPI.InstanceID )
2121: end,
2122: MSC_INT_ASCP_KPI.DemandFillRate,
2123: 1,
2124: -- supplier related columns
2125: -23453, --SUPPLIER_ID,
2126: -23453, --SUPPLIER_SITE_ID,

Line 2132: FROM MSC_INT_ASCP_KPI

2128: 0,-- TO_NUMBER(NULL) SUPPLIER_CAPACITY,
2129: 0,
2130: 0,
2131: SYSDATE, '-1', SYSDATE, '-1'
2132: FROM MSC_INT_ASCP_KPI
2133: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
2134: EXCEPTION WHEN others THEN
2135: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001010' || ' : ' || SQLERRM;
2136: raise;

Line 2133: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;

2129: 0,
2130: 0,
2131: SYSDATE, '-1', SYSDATE, '-1'
2132: FROM MSC_INT_ASCP_KPI
2133: WHERE MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
2134: EXCEPTION WHEN others THEN
2135: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001010' || ' : ' || SQLERRM;
2136: raise;
2137:

Line 2143: -- as msc_int_ascp_kpi, so we insert ditectly

2139:
2140: ----------------------------------------------
2141: -- Production cost: totalprodcost doesn't
2142: -- necessarily have same org-item combo
2143: -- as msc_int_ascp_kpi, so we insert ditectly
2144: -- from total prod cost
2145: ----------------------------------------------
2146: BEGIN
2147: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

Line 2184: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )

2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,
2181: msc_int_ascp_totalprodcost.OrganizationID,
2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
2185: 1,
2186: TO_DATE( msc_int_ascp_totalprodcost.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2187: 0, --TO_NUMBER(NULL) MDS_PRICE,
2188: -23453, -- ZONEID,