APPS.MSC_ATP_DRP dependencies on MSC_ATP_SUMMARY_SD

Line 382: INSERT INTO MSC_ATP_SUMMARY_SD (

378: msc_util.msc_log('******** LOAD_SD_FULL_DRP Begin ********');
379: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);
380: msc_util.msc_log('LOAD_SD_FULL_DRP p_sys_date ' || p_sys_date);
381:
382: INSERT INTO MSC_ATP_SUMMARY_SD (
383: plan_id,
384: sr_instance_id,
385: organization_id,
386: inventory_item_id,

Line 620: UPDATE MSC_ATP_SUMMARY_SD

616:
617: IF l_inventory_item_id_tab.COUNT > 0 THEN
618:
619: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
620: UPDATE MSC_ATP_SUMMARY_SD
621: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
622: last_update_date = p_sys_date,
623: last_updated_by = l_user_id
624: WHERE plan_id = p_plan_id

Line 657: INSERT INTO MSC_ATP_SUMMARY_SD (

653: IF l_ins_inventory_item_id_tab.COUNT > 0 THEN
654:
655:
656: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
657: INSERT INTO MSC_ATP_SUMMARY_SD (
658: plan_id,
659: sr_instance_id,
660: organization_id,
661: inventory_item_id,

Line 730: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */

726: -- SQL changed for summary enhancement
727: SELECT SD_DATE, SUM(SD_QTY)
728: BULK COLLECT INTO x_atp_dates, x_atp_qtys
729: FROM (
730: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
731: SD_DATE, SD_QTY
732: FROM MSC_ATP_SUMMARY_SD S
733: WHERE S.PLAN_ID = p_plan_id
734: AND S.SR_INSTANCE_ID = p_instance_id

Line 732: FROM MSC_ATP_SUMMARY_SD S

728: BULK COLLECT INTO x_atp_dates, x_atp_qtys
729: FROM (
730: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
731: SD_DATE, SD_QTY
732: FROM MSC_ATP_SUMMARY_SD S
733: WHERE S.PLAN_ID = p_plan_id
734: AND S.SR_INSTANCE_ID = p_instance_id
735: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
736: AND S.ORGANIZATION_ID = p_org_id