APPS.MSC_ATP_PF dependencies on MSC_ATP_SUMMARY_SD

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

2123: NVL(D.DEMAND_CLASS, NVL(p_default_dmd_class,'@@@')))
2124: AND D.sd_qty <> 0
2125: UNION ALL
2126:
2127: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2128: S.SD_DATE SD_DATE,
2129: S.SD_QTY SD_QTY
2130: FROM MSC_ATP_SUMMARY_SD S,
2131: MSC_ATP_RULES R,

Line 2130: FROM MSC_ATP_SUMMARY_SD S,

2126:
2127: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2128: S.SD_DATE SD_DATE,
2129: S.SD_QTY SD_QTY
2130: FROM MSC_ATP_SUMMARY_SD S,
2131: MSC_ATP_RULES R,
2132: MSC_SYSTEM_ITEMS I
2133: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2134: AND I.ORGANIZATION_ID = p_org_id

Line 2428: | - Additional union with MSC_ATP_SUMMARY_SD

2424:
2425: /*--Get_Mat_Avail_Pf_Pds_Summ----------------------------------------------------
2426: | o Called for unallocated time phased PF atp for PDS summary
2427: | o Differences from non summary SQL are :
2428: | - Additional union with MSC_ATP_SUMMARY_SD
2429: | - Decode in quantity in SQL on msc_alloc_demands to consider unscheduled
2430: | orders as dummy supplies
2431: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to
2432: | filter records based on refresh number

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

2456:
2457: SELECT SD_DATE, SUM(SD_QTY)
2458: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2459: FROM (
2460: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2461: SD_DATE, SD_QTY
2462: FROM MSC_ATP_SUMMARY_SD S,
2463: MSC_SYSTEM_ITEMS I
2464: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)

Line 2462: FROM MSC_ATP_SUMMARY_SD S,

2458: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2459: FROM (
2460: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2461: SD_DATE, SD_QTY
2462: FROM MSC_ATP_SUMMARY_SD S,
2463: MSC_SYSTEM_ITEMS I
2464: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2465: AND I.ORGANIZATION_ID = p_org_id
2466: AND I.SR_INSTANCE_ID = p_instance_id

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

5456: x_atp_dates,
5457: x_atp_qtys
5458: FROM
5459: (
5460: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5461: SD_DATE, SD_QTY
5462: FROM MSC_ATP_SUMMARY_SD S
5463: WHERE S.PLAN_ID = p_plan_id
5464: AND S.SR_INSTANCE_ID = p_instance_id

Line 5462: FROM MSC_ATP_SUMMARY_SD S

5458: FROM
5459: (
5460: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5461: SD_DATE, SD_QTY
5462: FROM MSC_ATP_SUMMARY_SD S
5463: WHERE S.PLAN_ID = p_plan_id
5464: AND S.SR_INSTANCE_ID = p_instance_id
5465: AND S.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5466: AND S.ORGANIZATION_ID = p_org_id

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

5910: x_atp_qtys,
5911: x_atp_dcs
5912: FROM
5913: (
5914: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5915: SD_DATE, SD_QTY, DEMAND_CLASS
5916: FROM MSC_ATP_SUMMARY_SD S
5917: WHERE S.PLAN_ID = p_plan_id
5918: AND S.SR_INSTANCE_ID = p_instance_id

Line 5916: FROM MSC_ATP_SUMMARY_SD S

5912: FROM
5913: (
5914: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5915: SD_DATE, SD_QTY, DEMAND_CLASS
5916: FROM MSC_ATP_SUMMARY_SD S
5917: WHERE S.PLAN_ID = p_plan_id
5918: AND S.SR_INSTANCE_ID = p_instance_id
5919: AND S.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5920: AND S.ORGANIZATION_ID = p_org_id