[Home] [Help]
2187: FROM (
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
2718: D.DEMAND_CLASS, --bug3263368
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
9095: decode(d1.inventory_item_id, NULL, '-2', d1.demand_class),
9096: sum(peg1.allocated_quantity)
9097: from
9098: (select distinct d.disposition_id transaction_id
9099: from msc_demands d,
9100: msc_system_items msi
9101: where msi.plan_id = p_plan_id
9102: and msi.bom_item_type <> 5
9103: and NVL(msi.product_family_id, -23453) <> -23453 -- Bug 3629191
9109: and d.plan_id = msi.plan_id
9110: and d.origination_type = 22
9111: ) sup,
9112: msc_full_pegging peg1,
9113: msc_demands d1
9114: where peg1.plan_id = p_plan_id
9115: and peg1.pegging_id = peg1.end_pegging_id
9116: and peg1.transaction_id = sup.transaction_id
9117: and d1.plan_id (+) = peg1.plan_id
9455: mat.demand_class),
9456: decode(mat.transaction_id, NULL, 1,
9457: mat.allocation_percent)
9458: from msc_full_pegging peg1,
9459: msc_demands d,
9460: msc_alloc_temp mat
9461: where peg1.plan_id = :p_plan_id
9462: and peg1.pegging_id = peg1.end_pegging_id
9463: and peg1.demand_id = d.demand_id
10285: msi.product_family_id) product_family_id ,
10286: decode(d.order_date_type_code,2,d.request_date,
10287: d.request_ship_date)request_date --bug3263368
10288: FROM msc_system_items msi,
10289: msc_demands d,
10290: msc_full_pegging peg,
10291: ' || p_alloc_temp_table || ' mat,
10292: msc_supplies s
10293: WHERE msi.plan_id = :p_plan_id
10440: :l_sysdate,
10441: decode(d.order_date_type_code,2,d.request_date,
10442: d.request_ship_date)request_date --bug3263368
10443: FROM msc_full_pegging peg1,
10444: msc_demands d,
10445: msc_supplies s,
10446: msc_system_items msi
10447: WHERE d.demand_id = peg1.demand_id
10448: AND d.plan_id = peg1.plan_id
10961: NULL, msi.inventory_item_id,
10962: msi.product_family_id) product_family_id
10963: FROM msc_full_pegging peg2,
10964: msc_full_pegging peg1,
10965: msc_demands d,
10966: msc_supplies s,
10967: msc_system_items msi
10968: WHERE peg1.plan_id = :p_plan_id
10969: AND peg2.plan_id = peg1.plan_id
11128: :l_user_id,
11129: :l_sysdate
11130: FROM msc_full_pegging peg2,
11131: msc_full_pegging peg1,
11132: msc_demands d,
11133: msc_supplies s,
11134: msc_system_items msi
11135: WHERE peg1.plan_id = :p_plan_id
11136: AND peg2.plan_id = peg1.plan_id
11315: :l_sysdate,
11316: :l_user_id,
11317: :l_sysdate
11318: FROM msc_full_pegging peg1,
11319: msc_demands d,
11320: msc_supplies s,
11321: msc_system_items msi
11322: WHERE d.demand_id = peg1.demand_id
11323: AND d.plan_id = peg1.plan_id
11566: d2.ship_to_site_id,
11567: decode(msi.aggregate_time_fence_date,
11568: NULL, msi.inventory_item_id,
11569: msi.product_family_id) product_family_id
11570: FROM msc_demands d2,
11571: msc_full_pegging peg2,
11572: msc_full_pegging peg1 ,
11573: msc_demands d1,
11574: msc_supplies s,
11569: msi.product_family_id) product_family_id
11570: FROM msc_demands d2,
11571: msc_full_pegging peg2,
11572: msc_full_pegging peg1 ,
11573: msc_demands d1,
11574: msc_supplies s,
11575: msc_system_items msi
11576: WHERE peg2.plan_id = :p_plan_id
11577: AND peg2.plan_id = peg1.plan_id
12070: msi.product_family_id) product_family_id
12071: FROM msc_supplies s,
12072: msc_full_pegging peg2,
12073: msc_full_pegging peg1,
12074: msc_demands d,
12075: msc_system_items msi
12076: WHERE peg2.plan_id = :p_plan_id
12077: AND peg2.plan_id = peg1.plan_id
12078: AND peg2.end_pegging_id = peg1.pegging_id