APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_MFG_PLAN_MACHINE

Line 1180: -- Fill in data from MSC_INT_ASCP_MFG_PLAN_MACHINE

1176:
1177: BEGIN
1178: -- CODE GOES HERE
1179: --
1180: -- Fill in data from MSC_INT_ASCP_MFG_PLAN_MACHINE
1181: -- Note that the temp table has resource and department id
1182: -- to distinguish records but these two ids are not relevant
1183: -- to supplies. As a result if we directly write to the table
1184: -- we will get duplcates. Change the selection base to pick unique rows.

Line 1206: from MSC_INT_ASCP_MFG_PLAN_MACHINE

1202: 2,
1203: SYSDATE, '-1', SYSDATE, '-1'
1204: from
1205: (select distinct organizationID, instanceID, itemID, PeriodEnd, flow
1206: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1207: where PLAN_ID=PlanIdVar AND CATEGORY='Manufacturing');
1208: EXCEPTION WHEN others THEN
1209: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_MFG_PLAN_MACHINE_001004';
1210: raise;

Line 1209: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_MFG_PLAN_MACHINE_001004';

1205: (select distinct organizationID, instanceID, itemID, PeriodEnd, flow
1206: from MSC_INT_ASCP_MFG_PLAN_MACHINE
1207: where PLAN_ID=PlanIdVar AND CATEGORY='Manufacturing');
1208: EXCEPTION WHEN others THEN
1209: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_MFG_PLAN_MACHINE_001004';
1210: raise;
1211: END;
1212:
1213:

Line 1593: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine

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

Line 1601: FROM msc_int_ascp_mfg_plan_machine

1597: itemID,
1598: periodEnd,
1599: prodCost )
1600: SELECT plan_id, organizationID, instanceID, itemID, periodEnd, SUM(resourcecost*resourceusage)
1601: FROM msc_int_ascp_mfg_plan_machine
1602: WHERE plan_id=PlanIdVar
1603: GROUP BY plan_id, organizationID, instanceID, itemID, periodEnd;
1604: EXCEPTION WHEN others THEN
1605: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001004';

Line 1611: -- fill in data from msc_int_ascp_mfg_plan_labour and msc_int_ascp_mfg_plan_machine

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