eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PF dependencies on MSC_DEMANDS

Line 2198: MSC_DEMANDS D,

2194: FROM (
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

Line 2734: MSC_DEMANDS D,

2730: D.DEMAND_CLASS, --bug3263368
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

Line 9125: from msc_demands d,

9121: decode(d1.inventory_item_id, NULL, '-2', d1.demand_class),
9122: sum(peg1.allocated_quantity)
9123: from
9124: (select /*+ NO_MERGE */ distinct d.disposition_id transaction_id --13021736 perf issue
9125: from msc_demands d,
9126: msc_system_items msi
9127: where msi.plan_id = p_plan_id
9128: and msi.bom_item_type <> 5
9129: and NVL(msi.product_family_id, -23453) <> -23453 -- Bug 3629191

Line 9139: msc_demands d1

9135: and d.plan_id = msi.plan_id
9136: and d.origination_type = 22
9137: ) sup,
9138: msc_full_pegging peg1,
9139: msc_demands d1
9140: where peg1.plan_id = p_plan_id
9141: and peg1.pegging_id = peg1.end_pegging_id
9142: and peg1.transaction_id = sup.transaction_id
9143: and d1.plan_id (+) = peg1.plan_id

Line 9485: msc_demands d,

9481: mat.demand_class),
9482: decode(mat.transaction_id, NULL, 1,
9483: mat.allocation_percent)
9484: from msc_full_pegging peg1,
9485: msc_demands d,
9486: msc_alloc_temp mat
9487: where peg1.plan_id = :p_plan_id
9488: and peg1.pegging_id = peg1.end_pegging_id
9489: and peg1.demand_id = d.demand_id

Line 10315: msc_demands d,

10311: msi.product_family_id) product_family_id ,
10312: decode(d.order_date_type_code,2,d.request_date,
10313: d.request_ship_date)request_date --bug3263368
10314: FROM msc_system_items msi,
10315: msc_demands d,
10316: msc_full_pegging peg,
10317: ' || p_alloc_temp_table || ' mat,
10318: msc_supplies s
10319: WHERE msi.plan_id = :p_plan_id

Line 10470: msc_demands d,

10466: :l_sysdate,
10467: decode(d.order_date_type_code,2,d.request_date,
10468: d.request_ship_date)request_date --bug3263368
10469: FROM msc_full_pegging peg1,
10470: msc_demands d,
10471: msc_supplies s,
10472: msc_system_items msi
10473: WHERE d.demand_id = peg1.demand_id
10474: AND d.plan_id = peg1.plan_id

Line 10991: msc_demands d,

10987: NULL, msi.inventory_item_id,
10988: msi.product_family_id) product_family_id
10989: FROM msc_full_pegging peg2,
10990: msc_full_pegging peg1,
10991: msc_demands d,
10992: msc_supplies s,
10993: msc_system_items msi
10994: WHERE peg1.plan_id = :p_plan_id
10995: AND peg2.plan_id = peg1.plan_id

Line 11158: msc_demands d,

11154: :l_user_id,
11155: :l_sysdate
11156: FROM msc_full_pegging peg2,
11157: msc_full_pegging peg1,
11158: msc_demands d,
11159: msc_supplies s,
11160: msc_system_items msi
11161: WHERE peg1.plan_id = :p_plan_id
11162: AND peg2.plan_id = peg1.plan_id

Line 11345: msc_demands d,

11341: :l_sysdate,
11342: :l_user_id,
11343: :l_sysdate
11344: FROM msc_full_pegging peg1,
11345: msc_demands d,
11346: msc_supplies s,
11347: msc_system_items msi
11348: WHERE d.demand_id = peg1.demand_id
11349: AND d.plan_id = peg1.plan_id

Line 11596: FROM msc_demands d2,

11592: d2.ship_to_site_id,
11593: decode(msi.aggregate_time_fence_date,
11594: NULL, msi.inventory_item_id,
11595: msi.product_family_id) product_family_id
11596: FROM msc_demands d2,
11597: msc_full_pegging peg2,
11598: msc_full_pegging peg1 ,
11599: msc_demands d1,
11600: msc_supplies s,

Line 11599: msc_demands d1,

11595: msi.product_family_id) product_family_id
11596: FROM msc_demands d2,
11597: msc_full_pegging peg2,
11598: msc_full_pegging peg1 ,
11599: msc_demands d1,
11600: msc_supplies s,
11601: msc_system_items msi
11602: WHERE peg2.plan_id = :p_plan_id
11603: AND peg2.plan_id = peg1.plan_id

Line 12100: msc_demands d,

12096: msi.product_family_id) product_family_id
12097: FROM msc_supplies s,
12098: msc_full_pegging peg2,
12099: msc_full_pegging peg1,
12100: msc_demands d,
12101: msc_system_items msi
12102: WHERE peg2.plan_id = :p_plan_id
12103: AND peg2.plan_id = peg1.plan_id
12104: AND peg2.end_pegging_id = peg1.pegging_id