APPS.MSC_ATP_REQ dependencies on MSC_DEMANDS

Line 1970: FROM MSC_DEMANDS D,

1966: SELECT TRUNC(NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)) SD_DATE,--plan by request,promise,schedule date
1967: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
1968: 0, nvl(D.OLD_DEMAND_QUANTITY,0), --4658238 -- For summary enhancement
1969: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
1970: FROM MSC_DEMANDS D,
1971: MSC_SYSTEM_ITEMS I,
1972: MSC_PLANS P -- For summary enhancement
1973: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1974: AND I.ORGANIZATION_ID = p_org_id

Line 2046: MSC_DEMANDS D,

2042: FROM (
2043: SELECT C.PRIOR_DATE SD_DATE,
2044: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2045: FROM MSC_CALENDAR_DATES C,
2046: MSC_DEMANDS D,
2047: MSC_ATP_RULES R,
2048: MSC_SYSTEM_ITEMS I
2049: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2050: AND I.ORGANIZATION_ID = p_org_id

Line 2286: FROM MSC_DEMANDS D,

2282: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
2283: --plan by requestdate,promisedate,scheduledate
2284: -- -1*D.USING_REQUIREMENT_QUANTITY SD_QTY
2285: -1*(D.USING_REQUIREMENT_QUANTITY - NVL(d.reserved_quantity, 0)) SD_QTY --5027568
2286: FROM MSC_DEMANDS D,
2287: MSC_SYSTEM_ITEMS I
2288: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2289: AND I.ORGANIZATION_ID = p_org_id
2290: AND I.SR_INSTANCE_ID = p_instance_id

Line 2372: MSC_DEMANDS D,

2368: 4, D.DAILY_DEMAND_RATE,
2369: --D.USING_REQUIREMENT_QUANTITY) SD_QTY
2370: (D.USING_REQUIREMENT_QUANTITY - NVL(d.reserved_quantity, 0))) SD_QTY --5027568
2371: FROM MSC_CALENDAR_DATES C,
2372: MSC_DEMANDS D,
2373: MSC_SYSTEM_ITEMS I
2374: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2375: AND I.ORGANIZATION_ID = p_org_id
2376: AND I.SR_INSTANCE_ID = p_instance_id

Line 2564: MSC_DEMANDS D,

2560: D.DEMAND_CLASS, --bug3263368
2561: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752
2562: D.REQUEST_SHIP_DATE)) --bug3263368
2563: FROM MSC_CALENDAR_DATES C,
2564: MSC_DEMANDS D,
2565: MSC_ATP_RULES R,
2566: MSC_SYSTEM_ITEMS I,
2567: MSC_TRADING_PARTNERS MTP,--bug3263368
2568: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 2964: MSC_DEMANDS D,

2960: D.DEMAND_CLASS, --bug3263368
2961: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2962: D.REQUEST_SHIP_DATE) --bug3263368
2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_DEMANDS D,
2965: MSC_TRADING_PARTNERS MTP,--bug3263368
2966: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2967: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2968: AND I.ORGANIZATION_ID = p_org_id

Line 3171: MSC_DEMANDS D,

3167: D.DEMAND_CLASS, --bug3263368
3168: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
3169: D.REQUEST_SHIP_DATE) --bug3263368
3170: FROM MSC_SYSTEM_ITEMS I,
3171: MSC_DEMANDS D,
3172: MSC_CALENDAR_DATES C,
3173: MSC_TRADING_PARTNERS MTP,--bug3263368
3174: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3175: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id