APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_MFG_PLAN_LABOUR

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 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,

Line 1620: FROM msc_int_ascp_mfg_plan_labour

1616: periodEnd,
1617: prodCost )
1618: SELECT plan_id, organizationID, instanceID, itemID, periodEnd, SUM
1619: (resourcecost*resourceusage)
1620: FROM msc_int_ascp_mfg_plan_labour
1621: WHERE plan_id=PlanIdVar
1622: GROUP BY plan_id, organizationID, instanceID, itemID, periodEnd;
1623: EXCEPTION WHEN others THEN
1624: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001005';