APPS.MSC_ATP_PF dependencies on MSC_ATP_SUMMARY_SD

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

2116: NVL(D.DEMAND_CLASS, NVL(p_default_dmd_class,'@@@')))
2117: AND D.sd_qty <> 0
2118: UNION ALL
2119:
2120: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2121: S.SD_DATE SD_DATE,
2122: S.SD_QTY SD_QTY
2123: FROM MSC_ATP_SUMMARY_SD S,
2124: MSC_ATP_RULES R,

Line 2123: FROM MSC_ATP_SUMMARY_SD S,

2119:
2120: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2121: S.SD_DATE SD_DATE,
2122: S.SD_QTY SD_QTY
2123: FROM MSC_ATP_SUMMARY_SD S,
2124: MSC_ATP_RULES R,
2125: MSC_SYSTEM_ITEMS I
2126: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2127: AND I.ORGANIZATION_ID = p_org_id

Line 2416: | - Additional union with MSC_ATP_SUMMARY_SD

2412:
2413: /*--Get_Mat_Avail_Pf_Pds_Summ----------------------------------------------------
2414: | o Called for unallocated time phased PF atp for PDS summary
2415: | o Differences from non summary SQL are :
2416: | - Additional union with MSC_ATP_SUMMARY_SD
2417: | - Decode in quantity in SQL on msc_alloc_demands to consider unscheduled
2418: | orders as dummy supplies
2419: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to
2420: | filter records based on refresh number

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

2444:
2445: SELECT SD_DATE, SUM(SD_QTY)
2446: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2447: FROM (
2448: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2449: SD_DATE, SD_QTY
2450: FROM MSC_ATP_SUMMARY_SD S,
2451: MSC_SYSTEM_ITEMS I
2452: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)

Line 2450: FROM MSC_ATP_SUMMARY_SD S,

2446: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2447: FROM (
2448: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
2449: SD_DATE, SD_QTY
2450: FROM MSC_ATP_SUMMARY_SD S,
2451: MSC_SYSTEM_ITEMS I
2452: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2453: AND I.ORGANIZATION_ID = p_org_id
2454: AND I.SR_INSTANCE_ID = p_instance_id

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

5430: x_atp_dates,
5431: x_atp_qtys
5432: FROM
5433: (
5434: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5435: SD_DATE, SD_QTY
5436: FROM MSC_ATP_SUMMARY_SD S
5437: WHERE S.PLAN_ID = p_plan_id
5438: AND S.SR_INSTANCE_ID = p_instance_id

Line 5436: FROM MSC_ATP_SUMMARY_SD S

5432: FROM
5433: (
5434: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5435: SD_DATE, SD_QTY
5436: FROM MSC_ATP_SUMMARY_SD S
5437: WHERE S.PLAN_ID = p_plan_id
5438: AND S.SR_INSTANCE_ID = p_instance_id
5439: AND S.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5440: AND S.ORGANIZATION_ID = p_org_id

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

5884: x_atp_qtys,
5885: x_atp_dcs
5886: FROM
5887: (
5888: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5889: SD_DATE, SD_QTY, DEMAND_CLASS
5890: FROM MSC_ATP_SUMMARY_SD S
5891: WHERE S.PLAN_ID = p_plan_id
5892: AND S.SR_INSTANCE_ID = p_instance_id

Line 5890: FROM MSC_ATP_SUMMARY_SD S

5886: FROM
5887: (
5888: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
5889: SD_DATE, SD_QTY, DEMAND_CLASS
5890: FROM MSC_ATP_SUMMARY_SD S
5891: WHERE S.PLAN_ID = p_plan_id
5892: AND S.SR_INSTANCE_ID = p_instance_id
5893: AND S.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5894: AND S.ORGANIZATION_ID = p_org_id