APPS.MSC_ATP_PF dependencies on MSC_ATP_RULES

Line 2094: MSC_ATP_RULES R,

2090: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2091: D.SD_DATE SD_DATE,
2092: -1* D.SD_QTY SD_QTY
2093: FROM MSC_ATP_SUMMARY_SO D,
2094: MSC_ATP_RULES R,
2095: MSC_SYSTEM_ITEMS I,
2096: MSC_SYSTEM_ITEMS I0
2097: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2098: AND I0.ORGANIZATION_ID = p_org_id

Line 2124: MSC_ATP_RULES R,

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
2128: AND I.SR_INSTANCE_ID = p_instance_id

Line 2192: MSC_ATP_RULES R,

2188: SELECT C.PRIOR_DATE SD_DATE,
2189: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2190: FROM MSC_CALENDAR_DATES C,
2191: MSC_DEMANDS D,
2192: MSC_ATP_RULES R,
2193: MSC_SYSTEM_ITEMS I,
2194: MSC_SYSTEM_ITEMS I0
2195: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2196: AND I0.ORGANIZATION_ID = p_org_id

Line 2243: MSC_ATP_RULES R,

2239: FROM
2240: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2241: --MSC_CALENDAR_DATES C,
2242: MSC_SALES_ORDERS D,
2243: MSC_ATP_RULES R,
2244: MSC_SYSTEM_ITEMS I,
2245: MSC_SYSTEM_ITEMS I0,
2246: MSC_CALENDAR_DATES C
2247: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id

Line 2311: MSC_ATP_RULES R,

2307: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2308: -- NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) )SD_QTY
2309: FROM MSC_CALENDAR_DATES C,
2310: MSC_SUPPLIES S,
2311: MSC_ATP_RULES R,
2312: MSC_SYSTEM_ITEMS I,
2313: MSC_SUB_INVENTORIES MSI
2314: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2315: AND I.ORGANIZATION_ID = p_org_id

Line 2723: MSC_ATP_RULES R,

2719: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2720: D.REQUEST_SHIP_DATE) --bug3263368
2721: FROM MSC_CALENDAR_DATES C,
2722: MSC_DEMANDS D,
2723: MSC_ATP_RULES R,
2724: MSC_SYSTEM_ITEMS I,
2725: MSC_SYSTEM_ITEMS I0,
2726: MSC_TRADING_PARTNERS MTP,--bug3263368
2727: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 2813: MSC_ATP_RULES R,

2809: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2810: D.REQUEST_SHIP_DATE) --bug3263368
2811: FROM
2812: MSC_SALES_ORDERS D,
2813: MSC_ATP_RULES R,
2814: MSC_SYSTEM_ITEMS I,
2815: MSC_SYSTEM_ITEMS I0,
2816: MSC_CALENDAR_DATES C,
2817: MSC_TRADING_PARTNERS MTP,--bug3263368

Line 2941: MSC_ATP_RULES R,

2937: l_null_char, --bug3814584
2938: l_null_date --bug3814584
2939: FROM MSC_CALENDAR_DATES C,
2940: MSC_SUPPLIES S,
2941: MSC_ATP_RULES R,
2942: MSC_SYSTEM_ITEMS I,
2943: MSC_SUB_INVENTORIES MSI
2944: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2945: AND I.ORGANIZATION_ID = p_org_id

Line 8595: msc_atp_rules r,

8591: )
8592: INTO l_atf_days
8593: FROM msc_system_items i2,
8594: msc_system_items i1,
8595: msc_atp_rules r,
8596: msc_trading_partners tp
8597: WHERE i1.inventory_item_id = p_inventory_item_id
8598: AND i1.organization_id = p_organization_id
8599: AND i1.plan_id = -1

Line 8896: msc_atp_rules r,

8892: FROM msc_plans mp,
8893: msc_plan_organizations po,
8894: msc_system_items i2,
8895: msc_trading_partners tp,
8896: msc_atp_rules r,
8897: msc_calendar_dates c1,
8898: msc_calendar_dates c2
8899: WHERE mp.plan_id = p_plan_id
8900: AND po.plan_id = mp.plan_id

Line 8961: msc_atp_rules r,

8957: SET aggregate_time_fence_date =
8958: (SELECT c2.calendar_date
8959: FROM msc_calendar_dates c2,
8960: msc_calendar_dates c1,
8961: msc_atp_rules r,
8962: msc_trading_partners tp,
8963: msc_plans mp,
8964: msc_system_items i2
8965: WHERE i2.inventory_item_id = i.inventory_item_id