APPS.MSC_ATP_DRP dependencies on MSC_ATP_SUMMARY_SD

Line 383: INSERT INTO MSC_ATP_SUMMARY_SD (

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

Line 621: UPDATE MSC_ATP_SUMMARY_SD

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

Line 658: INSERT INTO MSC_ATP_SUMMARY_SD (

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

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

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

Line 733: FROM MSC_ATP_SUMMARY_SD S

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