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_PRODCOST_KPI

Line 1718: DELETE FROM msc_int_ascp_prodcost_kpi; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??

1714:
1715: -- delete all from temporary tables to aid in the calculation of ProductionCost in the main procedure...
1716:
1717: BEGIN
1718: DELETE FROM msc_int_ascp_prodcost_kpi; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??
1719: EXCEPTION WHEN others THEN
1720: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001001' || ' : ' || SQLERRM;
1721: raise;
1722: END;

Line 1742: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,

1738:
1739: BEGIN
1740: -- CODE GOES HERE
1741: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine
1742: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,
1743: organizationID,
1744: instanceID,
1745: itemID,
1746: periodEnd,

Line 1760: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,

1756:
1757: BEGIN
1758: -- CODE GOES HERE
1759: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine
1760: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,
1761: organizationID,
1762: instanceID,
1763: itemID,
1764: periodEnd,

Line 1778: -- fill in data from msc_int_ascp_prodcost_kpi

1774: END;
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,

Line 1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,

1784: instanceID,
1785: itemID,
1786: periodEnd,
1787: totalProdCost )
1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,
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

Line 1789: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

1785: itemID,
1786: periodEnd,
1787: totalProdCost )
1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,
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

Line 1790: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,

1786: periodEnd,
1787: totalProdCost )
1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,
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

Line 1791: SUM(msc_int_ascp_prodcost_kpi.prodCost)

1787: totalProdCost )
1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,
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

Line 1792: FROM msc_int_ascp_prodcost_kpi

1788: SELECT msc_int_ascp_prodcost_kpi.plan_id,
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

Line 1796: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar -- AND

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
1800: --msc_int_ascp_prodcost_kpi.instanceID=MSC_INT_ASCP_KPI.InstanceID

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 1801: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,

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
1805: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006' || ' : ' || SQLERRM;

Line 1802: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

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
1805: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006' || ' : ' || SQLERRM;
1806: raise;

Line 1803: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;

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
1805: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006' || ' : ' || SQLERRM;
1806: raise;
1807: END;

Line 2294: --DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??

2290: g_ErrorCode VARCHAR2(1000);
2291: BEGIN
2292: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
2293: --BEGIN
2294: --DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??
2295: --EXCEPTION WHEN others THEN
2296: -- g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011' || ' : ' || SQLERRM;
2297: -- raise;
2298: --END;

Line 2301: --DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??

2297: -- raise;
2298: --END;
2299:
2300: --BEGIN
2301: --DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar; --??BUGBUG ??
2302: --EXCEPTION WHEN others THEN
2303: -- g_ErrorCode := 'ERROR_DELETE_msc_int_source2_001012' || ' : ' || SQLERRM;
2304: -- raise;
2305: --END;