APPS.MSC_ATP_REQ dependencies on MSC_ATP_SUMMARY_SD

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

1899: NVL(D.DEMAND_CLASS, NVL(p_default_dmd_class,'@@@')))
1900: AND D.SD_QTY <> 0
1901: UNION ALL
1902:
1903: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1904: trunc(S.SD_DATE) SD_DATE, --4135752
1905: S.SD_QTY SD_QTY
1906: FROM MSC_ATP_SUMMARY_SD S,
1907: MSC_ATP_RULES R,

Line 1906: FROM MSC_ATP_SUMMARY_SD S,

1902:
1903: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1904: trunc(S.SD_DATE) SD_DATE, --4135752
1905: S.SD_QTY SD_QTY
1906: FROM MSC_ATP_SUMMARY_SD S,
1907: MSC_ATP_RULES R,
1908: MSC_SYSTEM_ITEMS I
1909: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1910: AND I.ORGANIZATION_ID = p_org_id

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

1946: -- SQL changed for summary enhancement
1947: SELECT SD_DATE, SUM(SD_QTY)
1948: BULK COLLECT INTO x_atp_dates, x_atp_qtys
1949: FROM (
1950: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1951: SD_DATE, SD_QTY
1952: FROM MSC_ATP_SUMMARY_SD S,
1953: MSC_SYSTEM_ITEMS I
1954: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id

Line 1952: FROM MSC_ATP_SUMMARY_SD S,

1948: BULK COLLECT INTO x_atp_dates, x_atp_qtys
1949: FROM (
1950: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1951: SD_DATE, SD_QTY
1952: FROM MSC_ATP_SUMMARY_SD S,
1953: MSC_SYSTEM_ITEMS I
1954: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1955: AND I.ORGANIZATION_ID = p_org_id
1956: AND I.SR_INSTANCE_ID = p_instance_id