APPS.MSC_ATP_PVT dependencies on MSC_ATP_SUMMARY_SD

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

9289: null,
9290: null,
9291: null,
9292: 2);
9293: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
9294: set sd_qty = sd_qty + greatest(l_sub_requested_date_quantity, 0)
9295: where plan_id = p_plan_id
9296: and sr_instance_id = p_atp_record.instance_id
9297: and inventory_item_id = l_inventory_item_id

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

10059: null,
10060: null,
10061: 2);
10062:
10063: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
10064: set sd_qty = sd_qty + p_atp_record.quantity_ordered
10065: where plan_id = p_plan_id
10066: and sr_instance_id = p_atp_record.instance_id
10067: and organization_id = p_atp_record.organization_id

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

10084:
10085: IF PG_DEBUG in ('Y', 'C') THEN
10086: msc_sch_wb.atp_debug('ATP_Check: ' || 'update demand on new date');
10087: END IF;
10088: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
10089: set sd_qty = sd_qty - p_atp_record.quantity_ordered
10090: where plan_id = p_plan_id
10091: and sr_instance_id = p_atp_record.instance_id
10092: and organization_id = p_atp_record.organization_id

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

10418: null,
10419: 2);
10420:
10421:
10422: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
10423: set sd_qty = sd_qty + p_atp_record.quantity_ordered
10424: where plan_id = p_plan_id
10425: and inventory_item_id = l_inventory_item_id
10426: and sr_instance_id = p_atp_record.instance_id

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

15635: null,
15636: null,
15637: null,
15638: 2);
15639: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
15640: set sd_qty = sd_qty + l_atp_ctp_qty
15641: where plan_id = p_plan_id
15642: and sr_instance_id = p_atp_record.instance_id
15643: and inventory_item_id = l_inventory_item_id

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

15798: null,
15799: null,
15800: 2);
15801:
15802: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
15803: set sd_qty = sd_qty + l_net_demand
15804: where plan_id = p_plan_id
15805: and inventory_item_id = l_inventory_item_id
15806: and sr_instance_id = p_atp_record.instance_id

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

16017: null,
16018: null,
16019: 2);
16020:
16021: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
16022: set sd_qty = sd_qty + l_net_demand
16023: where plan_id = p_plan_id
16024: and inventory_item_id = l_inventory_item_id
16025: and sr_instance_id = p_atp_record.instance_id

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

16183: null,
16184: 2);
16185:
16186:
16187: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
16188: set sd_qty = (sd_qty + p_atp_record.quantity_ordered)
16189: where sr_instance_id = p_atp_record.instance_id and
16190: inventory_item_id = l_inventory_item_id and
16191: organization_id = p_atp_record.organization_id and

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

16210: null,
16211: null,
16212: 2);
16213:
16214: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
16215: set sd_qty = sd_qty - p_atp_record.quantity_ordered
16216: where plan_id = p_plan_id and
16217: sr_instance_id = p_atp_record.instance_id and
16218: inventory_item_id = l_inventory_item_id and