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_FULL_PEGGING

Line 9138: msc_full_pegging peg1,

9134: and d.sr_instance_id = msi.sr_instance_id
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

Line 9472: from msc_full_pegging peg1

9468: )
9469: (select peg1.pegging_id,
9470: :l_excess_dc,
9471: 1
9472: from msc_full_pegging peg1
9473: where peg1.plan_id = :p_plan_id
9474: and peg1.pegging_id = peg1.end_pegging_id
9475: and peg1.demand_id in (-1, -2)
9476:

Line 9484: from msc_full_pegging peg1,

9480: decode(mat.transaction_id, NULL, d.demand_class,
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

Line 10316: msc_full_pegging peg,

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
10320: AND msi.atp_flag = :l_yes

Line 10328: AND peg.sr_instance_id = d.sr_instance_id --bug3453289 MSC_FULL_PEGGING_N2

10324: AND d.organization_id = msi.organization_id
10325: AND d.origination_type NOT IN (5,7,8,9,11,15,22,28,29,31,70)
10326: AND peg.plan_id = d.plan_id
10327: AND peg.demand_id = d.demand_id
10328: AND peg.sr_instance_id = d.sr_instance_id --bug3453289 MSC_FULL_PEGGING_N2
10329: AND peg.organization_id= d.organization_id --bug3453289 MSC_FULL_PEGGING_N2
10330: AND mat.pegging_id = peg.end_pegging_id
10331: AND s.sr_instance_id = peg.sr_instance_id
10332: AND s.plan_id = peg.plan_id

Line 10329: AND peg.organization_id= d.organization_id --bug3453289 MSC_FULL_PEGGING_N2

10325: AND d.origination_type NOT IN (5,7,8,9,11,15,22,28,29,31,70)
10326: AND peg.plan_id = d.plan_id
10327: AND peg.demand_id = d.demand_id
10328: AND peg.sr_instance_id = d.sr_instance_id --bug3453289 MSC_FULL_PEGGING_N2
10329: AND peg.organization_id= d.organization_id --bug3453289 MSC_FULL_PEGGING_N2
10330: AND mat.pegging_id = peg.end_pegging_id
10331: AND s.sr_instance_id = peg.sr_instance_id
10332: AND s.plan_id = peg.plan_id
10333: AND s.transaction_id = peg.transaction_id) pegging_v,

Line 10469: FROM msc_full_pegging peg1,

10465: :l_user_id,
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

Line 10689: msc_full_pegging peg,

10685: NULL, msi.inventory_item_id,
10686: msi.product_family_id) product_family_id
10687: FROM msc_system_items msi,
10688: msc_supplies s,
10689: msc_full_pegging peg,
10690: ' || p_alloc_temp_table || ' mat
10691: WHERE msi.plan_id = :p_plan_id
10692: AND msi.atp_flag = :l_yes
10693: AND s.plan_id = msi.plan_id --bug3453289

Line 10989: FROM msc_full_pegging peg2,

10985: /* New Allocation logic for time phased ATP */
10986: /* decode(msi.aggregate_time_fence_date,
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

Line 10990: msc_full_pegging peg1,

10986: /* decode(msi.aggregate_time_fence_date,
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

Line 11156: FROM msc_full_pegging peg2,

11152: :l_user_id,
11153: :l_sysdate,
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

Line 11157: msc_full_pegging peg1,

11153: :l_sysdate,
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

Line 11344: FROM msc_full_pegging peg1,

11340: :l_user_id,
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

Line 11597: msc_full_pegging peg2,

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,
11601: msc_system_items msi

Line 11598: msc_full_pegging peg1 ,

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,
11601: msc_system_items msi
11602: WHERE peg2.plan_id = :p_plan_id

Line 11786: FROM msc_full_pegging peg2,

11782: s.ship_to_site_id,
11783: decode(msi.aggregate_time_fence_date,
11784: NULL, msi.inventory_item_id,
11785: msi.product_family_id) product_family_id
11786: FROM msc_full_pegging peg2,
11787: msc_full_pegging peg1,
11788: msc_supplies s,
11789: msc_system_items msi
11790: WHERE peg1.plan_id = :p_plan_id

Line 11787: msc_full_pegging peg1,

11783: decode(msi.aggregate_time_fence_date,
11784: NULL, msi.inventory_item_id,
11785: msi.product_family_id) product_family_id
11786: FROM msc_full_pegging peg2,
11787: msc_full_pegging peg1,
11788: msc_supplies s,
11789: msc_system_items msi
11790: WHERE peg1.plan_id = :p_plan_id
11791: AND peg2.plan_id = peg1.plan_id

Line 11886: FROM msc_full_pegging peg2,

11882: :l_user_id created_by,
11883: :l_sysdate creation_date,
11884: :l_user_id last_updated_by,
11885: :l_sysdate last_update_date
11886: FROM msc_full_pegging peg2,
11887: msc_full_pegging peg1,
11888: msc_supplies s,
11889: msc_system_items msi
11890: WHERE peg1.plan_id = :p_plan_id

Line 11887: msc_full_pegging peg1,

11883: :l_sysdate creation_date,
11884: :l_user_id last_updated_by,
11885: :l_sysdate last_update_date
11886: FROM msc_full_pegging peg2,
11887: msc_full_pegging peg1,
11888: msc_supplies s,
11889: msc_system_items msi
11890: WHERE peg1.plan_id = :p_plan_id
11891: AND peg2.plan_id = peg1.plan_id

Line 12098: msc_full_pegging peg2,

12094: decode(msi.aggregate_time_fence_date,
12095: NULL, msi.inventory_item_id,
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

Line 12099: msc_full_pegging peg1,

12095: NULL, msi.inventory_item_id,
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