APPS.MSC_ATP_PF dependencies on MSC_ATP_RULES

Line 2101: MSC_ATP_RULES R,

2097: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2098: D.SD_DATE SD_DATE,
2099: -1* D.SD_QTY SD_QTY
2100: FROM MSC_ATP_SUMMARY_SO D,
2101: MSC_ATP_RULES R,
2102: MSC_SYSTEM_ITEMS I,
2103: MSC_SYSTEM_ITEMS I0
2104: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2105: AND I0.ORGANIZATION_ID = p_org_id

Line 2131: MSC_ATP_RULES R,

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

Line 2199: MSC_ATP_RULES R,

2195: SELECT C.PRIOR_DATE SD_DATE,
2196: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2197: FROM MSC_CALENDAR_DATES C,
2198: MSC_DEMANDS D,
2199: MSC_ATP_RULES R,
2200: MSC_SYSTEM_ITEMS I,
2201: MSC_SYSTEM_ITEMS I0
2202: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2203: AND I0.ORGANIZATION_ID = p_org_id

Line 2250: MSC_ATP_RULES R,

2246: FROM
2247: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2248: --MSC_CALENDAR_DATES C,
2249: MSC_SALES_ORDERS D,
2250: MSC_ATP_RULES R,
2251: MSC_SYSTEM_ITEMS I,
2252: MSC_SYSTEM_ITEMS I0,
2253: MSC_CALENDAR_DATES C
2254: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id

Line 2318: MSC_ATP_RULES R,

2314: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2315: -- NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) )SD_QTY
2316: FROM MSC_CALENDAR_DATES C,
2317: MSC_SUPPLIES S,
2318: MSC_ATP_RULES R,
2319: MSC_SYSTEM_ITEMS I,
2320: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2321: MSC_SUB_INVENTORIES MSI
2322: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id -- Bug 13072988, aggregate the supply of member-items

Line 2735: MSC_ATP_RULES R,

2731: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2732: D.REQUEST_SHIP_DATE) --bug3263368
2733: FROM MSC_CALENDAR_DATES C,
2734: MSC_DEMANDS D,
2735: MSC_ATP_RULES R,
2736: MSC_SYSTEM_ITEMS I,
2737: MSC_SYSTEM_ITEMS I0,
2738: MSC_TRADING_PARTNERS MTP,--bug3263368
2739: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 2825: MSC_ATP_RULES R,

2821: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2822: D.REQUEST_SHIP_DATE) --bug3263368
2823: FROM
2824: MSC_SALES_ORDERS D,
2825: MSC_ATP_RULES R,
2826: MSC_SYSTEM_ITEMS I,
2827: MSC_SYSTEM_ITEMS I0,
2828: MSC_CALENDAR_DATES C,
2829: MSC_TRADING_PARTNERS MTP,--bug3263368

Line 2953: MSC_ATP_RULES R,

2949: l_null_char, --bug3814584
2950: l_null_date --bug3814584
2951: FROM MSC_CALENDAR_DATES C,
2952: MSC_SUPPLIES S,
2953: MSC_ATP_RULES R,
2954: MSC_SYSTEM_ITEMS I,
2955: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2956: MSC_SUB_INVENTORIES MSI
2957: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id -- Bug 13072988, aggregate the supply of member-items

Line 8621: msc_atp_rules r,

8617: )
8618: INTO l_atf_days
8619: FROM msc_system_items i2,
8620: msc_system_items i1,
8621: msc_atp_rules r,
8622: msc_trading_partners tp
8623: WHERE i1.inventory_item_id = p_inventory_item_id
8624: AND i1.organization_id = p_organization_id
8625: AND i1.plan_id = -1

Line 8922: msc_atp_rules r,

8918: FROM msc_plans mp,
8919: msc_plan_organizations po,
8920: msc_system_items i2,
8921: msc_trading_partners tp,
8922: msc_atp_rules r,
8923: msc_calendar_dates c1,
8924: msc_calendar_dates c2
8925: WHERE mp.plan_id = p_plan_id
8926: AND po.plan_id = mp.plan_id

Line 8987: msc_atp_rules r,

8983: SET aggregate_time_fence_date =
8984: (SELECT c2.calendar_date
8985: FROM msc_calendar_dates c2,
8986: msc_calendar_dates c1,
8987: msc_atp_rules r,
8988: msc_trading_partners tp,
8989: msc_plans mp,
8990: msc_system_items i2
8991: WHERE i2.inventory_item_id = i.inventory_item_id