APPS.MSC_ATP_PVT dependencies on MSC_ATP_SUMMARY_SD

Line 8601: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

8597: null,
8598: null,
8599: null,
8600: 2);
8601: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
8602: set sd_qty = sd_qty + greatest(l_sub_requested_date_quantity, 0)
8603: where plan_id = p_plan_id
8604: and sr_instance_id = p_atp_record.instance_id
8605: and inventory_item_id = l_inventory_item_id

Line 9357: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

9353: null,
9354: null,
9355: 2);
9356:
9357: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
9358: set sd_qty = sd_qty + p_atp_record.quantity_ordered
9359: where plan_id = p_plan_id
9360: and sr_instance_id = p_atp_record.instance_id
9361: and organization_id = p_atp_record.organization_id

Line 9382: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

9378:
9379: IF PG_DEBUG in ('Y', 'C') THEN
9380: msc_sch_wb.atp_debug('ATP_Check: ' || 'update demand on new date');
9381: END IF;
9382: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
9383: set sd_qty = sd_qty - p_atp_record.quantity_ordered
9384: where plan_id = p_plan_id
9385: and sr_instance_id = p_atp_record.instance_id
9386: and organization_id = p_atp_record.organization_id

Line 9715: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

9711: null,
9712: 2);
9713:
9714:
9715: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
9716: set sd_qty = sd_qty + p_atp_record.quantity_ordered
9717: where plan_id = p_plan_id
9718: and inventory_item_id = l_inventory_item_id
9719: and sr_instance_id = p_atp_record.instance_id

Line 14797: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

14793: null,
14794: null,
14795: null,
14796: 2);
14797: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
14798: set sd_qty = sd_qty + l_atp_ctp_qty
14799: where plan_id = p_plan_id
14800: and sr_instance_id = p_atp_record.instance_id
14801: and inventory_item_id = l_inventory_item_id

Line 14958: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

14954: null,
14955: null,
14956: 2);
14957:
14958: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
14959: set sd_qty = sd_qty + l_net_demand
14960: where plan_id = p_plan_id
14961: and inventory_item_id = l_inventory_item_id
14962: and sr_instance_id = p_atp_record.instance_id

Line 15171: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

15167: null,
15168: null,
15169: 2);
15170:
15171: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
15172: set sd_qty = sd_qty + l_net_demand
15173: where plan_id = p_plan_id
15174: and inventory_item_id = l_inventory_item_id
15175: and sr_instance_id = p_atp_record.instance_id

Line 15336: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD

15332: null,
15333: 2);
15334:
15335:
15336: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
15337: set sd_qty = (sd_qty + p_atp_record.quantity_ordered)
15338: where sr_instance_id = p_atp_record.instance_id and
15339: inventory_item_id = l_inventory_item_id and
15340: organization_id = p_atp_record.organization_id and

Line 15363: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd

15359: null,
15360: null,
15361: 2);
15362:
15363: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
15364: set sd_qty = sd_qty - p_atp_record.quantity_ordered
15365: where plan_id = p_plan_id and
15366: sr_instance_id = p_atp_record.instance_id and
15367: inventory_item_id = l_inventory_item_id and