APPS.MSC_AATP_REQ dependencies on MSC_ATP_SUMMARY_SD

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

144: l_current_atp.atp_period,
145: l_current_atp.atp_qty
146: FROM
147: (
148: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
149: SD_DATE, SD_QTY
150: FROM MSC_ATP_SUMMARY_SD S
151: WHERE S.PLAN_ID = p_plan_id
152: AND S.SR_INSTANCE_ID = p_instance_id

Line 150: FROM MSC_ATP_SUMMARY_SD S

146: FROM
147: (
148: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
149: SD_DATE, SD_QTY
150: FROM MSC_ATP_SUMMARY_SD S
151: WHERE S.PLAN_ID = p_plan_id
152: AND S.SR_INSTANCE_ID = p_instance_id
153: AND S.INVENTORY_ITEM_ID = l_inv_item_id
154: AND S.ORGANIZATION_ID = p_organization_id

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

1165: l_atp_qty_tab,
1166: l_atp_dc_tab
1167: FROM
1168: (
1169: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1170: SD_DATE, SD_QTY, DEMAND_CLASS
1171: FROM MSC_ATP_SUMMARY_SD S
1172: WHERE S.PLAN_ID = p_plan_id
1173: AND S.SR_INSTANCE_ID = p_instance_id

Line 1171: FROM MSC_ATP_SUMMARY_SD S

1167: FROM
1168: (
1169: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1170: SD_DATE, SD_QTY, DEMAND_CLASS
1171: FROM MSC_ATP_SUMMARY_SD S
1172: WHERE S.PLAN_ID = p_plan_id
1173: AND S.SR_INSTANCE_ID = p_instance_id
1174: AND S.INVENTORY_ITEM_ID = l_inv_item_id
1175: AND S.ORGANIZATION_ID = p_organization_id