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 1564: DELETE FROM msc_int_ascp_prodcost_kpi; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;

1560:
1561: -- delete all from temporary tables to aid in the calculation of ProductionCost in the main procedure...
1562:
1563: BEGIN
1564: DELETE FROM msc_int_ascp_prodcost_kpi; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1565: EXCEPTION WHEN others THEN
1566: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001001';
1567: raise;
1568: END;

Line 1594: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,

1590:
1591: BEGIN
1592: -- CODE GOES HERE
1593: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine
1594: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,
1595: organizationID,
1596: instanceID,
1597: itemID,
1598: periodEnd,

Line 1612: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,

1608:
1609: BEGIN
1610: -- CODE GOES HERE
1611: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine
1612: INSERT INTO msc_int_ascp_prodcost_kpi ( plan_id,
1613: organizationID,
1614: instanceID,
1615: itemID,
1616: periodEnd,

Line 1630: -- fill in data from msc_int_ascp_prodcost_kpi

1626: END;
1627:
1628: BEGIN
1629: -- CODE GOES HERE
1630: -- fill in data from msc_int_ascp_prodcost_kpi
1631: INSERT INTO msc_int_ascp_totalprodcost ( plan_id,
1632: organizationID,
1633: instanceID,
1634: itemID,

Line 1637: SELECT msc_int_ascp_prodcost_kpi.plan_id,

1633: instanceID,
1634: itemID,
1635: periodEnd,
1636: totalProdCost )
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

Line 1638: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

1634: itemID,
1635: periodEnd,
1636: totalProdCost )
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

Line 1639: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.periodEnd,

1635: periodEnd,
1636: totalProdCost )
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

Line 1640: SUM(msc_int_ascp_prodcost_kpi.prodCost)

1636: totalProdCost )
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

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 1644: msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar AND

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
1648: msc_int_ascp_prodcost_kpi.periodEnd=MSC_INT_ASCP_KPI.PERIODEND 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 1650: GROUP BY msc_int_ascp_prodcost_kpi.plan_id,

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

Line 1651: msc_int_ascp_prodcost_kpi.organizationID, msc_int_ascp_prodcost_kpi.instanceID,

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
1654: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006';
1655: raise;

Line 1652: msc_int_ascp_prodcost_kpi.itemID, msc_int_ascp_prodcost_kpi.PeriodEnd;

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
1654: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006';
1655: raise;
1656: END;

Line 1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;

1928: BEGIN
1929: /* implementation starts here */
1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
1931: BEGIN
1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1933: EXCEPTION WHEN others THEN
1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';
1935: raise;
1936: END;

Line 1939: DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;

1935: raise;
1936: END;
1937:
1938: BEGIN
1939: DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1940: EXCEPTION WHEN others THEN
1941: g_ErrorCode := 'ERROR_DELETE_msc_int_source2_001012';
1942: raise;
1943: END;