APPS.MSC_ATP_REQ dependencies on MSC_ATP_SUMMARY_SUP

Line 11527: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */

11523: SUM(SD_QTY)
11524: BULK COLLECT INTO l_atp_period_tab, l_atp_qty_tab
11525: FROM
11526: (
11527: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */
11528: sd_date,
11529: sd_qty
11530: from msc_atp_summary_sup
11531: where plan_id = p_sup_atp_info_rec.plan_id

Line 11530: from msc_atp_summary_sup

11526: (
11527: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */
11528: sd_date,
11529: sd_qty
11530: from msc_atp_summary_sup
11531: where plan_id = p_sup_atp_info_rec.plan_id
11532: and sr_instance_id = p_sup_atp_info_rec.instance_id
11533: and supplier_id = p_sup_atp_info_rec.supplier_id
11534: and supplier_site_id = p_sup_atp_info_rec.supplier_site_id

Line 11591: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */

11587: SUM(SD_QTY)
11588: BULK COLLECT INTO l_atp_period_tab, l_atp_qty_tab
11589: FROM
11590: (
11591: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */
11592: trunc( sd_date) SD_DATE, --4135752
11593: sd_qty
11594: from msc_atp_summary_sup
11595: where plan_id = p_sup_atp_info_rec.plan_id

Line 11594: from msc_atp_summary_sup

11590: (
11591: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */
11592: trunc( sd_date) SD_DATE, --4135752
11593: sd_qty
11594: from msc_atp_summary_sup
11595: where plan_id = p_sup_atp_info_rec.plan_id
11596: and sr_instance_id = p_sup_atp_info_rec.instance_id
11597: and inventory_item_id = p_sup_atp_info_rec.inventory_item_id
11598: and supplier_id = p_sup_atp_info_rec.supplier_id