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_TOTALPRODCOST

Line 1571: DELETE FROM msc_int_ascp_totalprodcost; -- where msc_int_ascp_totalprodcost.plan_id=PlanIdVar;

1567: raise;
1568: END;
1569:
1570: BEGIN
1571: DELETE FROM msc_int_ascp_totalprodcost; -- where msc_int_ascp_totalprodcost.plan_id=PlanIdVar;
1572: EXCEPTION WHEN others THEN
1573: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001002';
1574: raise;
1575: END;

Line 1631: INSERT INTO msc_int_ascp_totalprodcost ( plan_id,

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

Line 1798: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

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
1801: AND
1802: ItemID=MSC_INT_ASCP_KPI.ItemID AND

Line 1807: msc_int_ascp_totalprodcost

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
1809: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1810: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1811: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 1856: case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

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
1857: WHERE PLAN_ID=PlanIdVar AND
1858: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID
1859: AND
1860: ItemID=MSC_INT_ASCP_KPI.ItemID AND

Line 1865: msc_int_ascp_totalprodcost

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
1867: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1868: ItemID=MSC_INT_ASCP_KPI.ItemID AND
1869: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND