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 9112: msc_full_pegging peg1,

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

Line 9446: from msc_full_pegging peg1

9442: )
9443: (select peg1.pegging_id,
9444: :l_excess_dc,
9445: 1
9446: from msc_full_pegging peg1
9447: where peg1.plan_id = :p_plan_id
9448: and peg1.pegging_id = peg1.end_pegging_id
9449: and peg1.demand_id in (-1, -2)
9450:

Line 9458: from msc_full_pegging peg1,

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

Line 10290: msc_full_pegging peg,

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

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

10298: AND d.organization_id = msi.organization_id
10299: AND d.origination_type NOT IN (5,7,8,9,11,15,22,28,29,31)
10300: AND peg.plan_id = d.plan_id
10301: AND peg.demand_id = d.demand_id
10302: AND peg.sr_instance_id = d.sr_instance_id --bug3453289 MSC_FULL_PEGGING_N2
10303: AND peg.organization_id= d.organization_id --bug3453289 MSC_FULL_PEGGING_N2
10304: AND mat.pegging_id = peg.end_pegging_id
10305: AND s.sr_instance_id = peg.sr_instance_id
10306: AND s.plan_id = peg.plan_id

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

10299: AND d.origination_type NOT IN (5,7,8,9,11,15,22,28,29,31)
10300: AND peg.plan_id = d.plan_id
10301: AND peg.demand_id = d.demand_id
10302: AND peg.sr_instance_id = d.sr_instance_id --bug3453289 MSC_FULL_PEGGING_N2
10303: AND peg.organization_id= d.organization_id --bug3453289 MSC_FULL_PEGGING_N2
10304: AND mat.pegging_id = peg.end_pegging_id
10305: AND s.sr_instance_id = peg.sr_instance_id
10306: AND s.plan_id = peg.plan_id
10307: AND s.transaction_id = peg.transaction_id) pegging_v,

Line 10443: FROM msc_full_pegging peg1,

10439: :l_user_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

Line 10663: msc_full_pegging peg,

10659: NULL, msi.inventory_item_id,
10660: msi.product_family_id) product_family_id
10661: FROM msc_system_items msi,
10662: msc_supplies s,
10663: msc_full_pegging peg,
10664: ' || p_alloc_temp_table || ' mat
10665: WHERE msi.plan_id = :p_plan_id
10666: AND msi.atp_flag = :l_yes
10667: AND s.plan_id = msi.plan_id --bug3453289

Line 10963: FROM msc_full_pegging peg2,

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

Line 10964: msc_full_pegging peg1,

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

Line 11130: FROM msc_full_pegging peg2,

11126: :l_user_id,
11127: :l_sysdate,
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

Line 11131: msc_full_pegging peg1,

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

Line 11318: FROM msc_full_pegging peg1,

11314: :l_user_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

Line 11571: msc_full_pegging peg2,

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

Line 11572: msc_full_pegging peg1 ,

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

Line 11760: FROM msc_full_pegging peg2,

11756: s.ship_to_site_id,
11757: decode(msi.aggregate_time_fence_date,
11758: NULL, msi.inventory_item_id,
11759: msi.product_family_id) product_family_id
11760: FROM msc_full_pegging peg2,
11761: msc_full_pegging peg1,
11762: msc_supplies s,
11763: msc_system_items msi
11764: WHERE peg1.plan_id = :p_plan_id

Line 11761: msc_full_pegging peg1,

11757: decode(msi.aggregate_time_fence_date,
11758: NULL, msi.inventory_item_id,
11759: msi.product_family_id) product_family_id
11760: FROM msc_full_pegging peg2,
11761: msc_full_pegging peg1,
11762: msc_supplies s,
11763: msc_system_items msi
11764: WHERE peg1.plan_id = :p_plan_id
11765: AND peg2.plan_id = peg1.plan_id

Line 11860: FROM msc_full_pegging peg2,

11856: :l_user_id created_by,
11857: :l_sysdate creation_date,
11858: :l_user_id last_updated_by,
11859: :l_sysdate last_update_date
11860: FROM msc_full_pegging peg2,
11861: msc_full_pegging peg1,
11862: msc_supplies s,
11863: msc_system_items msi
11864: WHERE peg1.plan_id = :p_plan_id

Line 11861: msc_full_pegging peg1,

11857: :l_sysdate creation_date,
11858: :l_user_id last_updated_by,
11859: :l_sysdate last_update_date
11860: FROM msc_full_pegging peg2,
11861: msc_full_pegging peg1,
11862: msc_supplies s,
11863: msc_system_items msi
11864: WHERE peg1.plan_id = :p_plan_id
11865: AND peg2.plan_id = peg1.plan_id

Line 12072: msc_full_pegging peg2,

12068: decode(msi.aggregate_time_fence_date,
12069: NULL, msi.inventory_item_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

Line 12073: msc_full_pegging peg1,

12069: NULL, msi.inventory_item_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