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_SUPPLIES_S

Line 1695: --SELECT msc_supplies_s.nextval into p_transaction_id from dual;

1691: l_mem_stealing_rec_date := p_ship_date;
1692: END IF;
1693:
1694: --bug3555084 using returning clause in place of select
1695: --SELECT msc_supplies_s.nextval into p_transaction_id from dual;
1696:
1697: IF p_mem_stealing_quantity > 0 THEN
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');

Line 1715: --bug3555084 using msc_supplies_s.nextval in place of p_transaction_id

1711: )
1712: VALUES
1713: (p_plan_id, p_mem_item_id, p_organization_id,
1714: p_sr_instance_id, p_stealing_demand_class, l_mem_stealing_rec_date,
1715: --bug3555084 using msc_supplies_s.nextval in place of p_transaction_id
1716: msc_supplies_s.nextval, p_mem_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1717: p_mem_stealing_quantity, p_mem_item_id, 46,
1718: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_ato_model_line_id, p_refresh_number,
1719: --bug3684383

Line 1716: msc_supplies_s.nextval, p_mem_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro

1712: VALUES
1713: (p_plan_id, p_mem_item_id, p_organization_id,
1714: p_sr_instance_id, p_stealing_demand_class, l_mem_stealing_rec_date,
1715: --bug3555084 using msc_supplies_s.nextval in place of p_transaction_id
1716: msc_supplies_s.nextval, p_mem_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1717: p_mem_stealing_quantity, p_mem_item_id, 46,
1718: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_ato_model_line_id, p_refresh_number,
1719: --bug3684383
1720: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID) -- For summary enhancement

Line 1788: msc_supplies_s.nextval, p_pf_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro

1784: order_number,customer_id,ship_to_site_id)
1785: VALUES
1786: (p_plan_id, p_pf_item_id, p_organization_id,
1787: p_sr_instance_id, p_stealing_demand_class, l_pf_stealing_rec_date,
1788: msc_supplies_s.nextval, p_pf_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1789: p_pf_stealing_quantity, p_mem_item_id, 46,
1790: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_refresh_number, -- For summary enhancement
1791: --bug3684383
1792: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID)

Line 2317: MSC_SUPPLIES S,

2313:
2314: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2315: -- NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) )SD_QTY
2316: FROM MSC_CALENDAR_DATES C,
2317: MSC_SUPPLIES S,
2318: MSC_ATP_RULES R,
2319: MSC_SYSTEM_ITEMS I,
2320: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2321: MSC_SUB_INVENTORIES MSI

Line 2952: MSC_SUPPLIES S,

2948: l_null_char, --bug3814584
2949: l_null_char, --bug3814584
2950: l_null_date --bug3814584
2951: FROM MSC_CALENDAR_DATES C,
2952: MSC_SUPPLIES S,
2953: MSC_ATP_RULES R,
2954: MSC_SYSTEM_ITEMS I,
2955: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2956: MSC_SUB_INVENTORIES MSI

Line 10318: msc_supplies s

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
10321: AND msi.plan_id = d.plan_id --bug3453289
10322: AND d.inventory_item_id = msi.inventory_item_id

Line 10471: msc_supplies s,

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
10475: AND d.sr_instance_id = peg1.sr_instance_id

Line 10688: msc_supplies s,

10684: decode(msi.aggregate_time_fence_date,
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

Line 10775: from msc_supplies s,

10771: :l_user_id,
10772: :l_sysdate,
10773: :l_user_id,
10774: :l_sysdate
10775: from msc_supplies s,
10776: msc_system_items i
10777: where i.aggregate_time_fence_date is not null
10778: and i.bom_item_type <> 5
10779: and i.plan_id = :p_plan_id

Line 10992: msc_supplies s,

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
10996: AND peg2.pegging_id = peg1.end_pegging_id

Line 11159: msc_supplies s,

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
11163: AND peg2.pegging_id = peg1.end_pegging_id

Line 11346: msc_supplies s,

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
11350: AND d.sr_instance_id = peg1.sr_instance_id

Line 11600: msc_supplies s,

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
11604: AND peg2.end_pegging_id = peg1.pegging_id

Line 11788: msc_supplies s,

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
11792: AND peg2.pegging_id = peg1.end_pegging_id

Line 11888: msc_supplies s,

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
11892: AND peg2.pegging_id = peg1.end_pegging_id

Line 11971: from msc_supplies s,

11967: :l_user_id,
11968: :l_sysdate,
11969: :l_user_id,
11970: :l_sysdate
11971: from msc_supplies s,
11972: msc_system_items i
11973: where i.aggregate_time_fence_date is not null
11974: and i.bom_item_type <> 5
11975: and i.plan_id = :p_plan_id

Line 12097: FROM msc_supplies s,

12093: s.ship_to_site_id,
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

Line 12383: msc_supplies s

12379: mapt.atf_date atf_date,
12380: mapt.product_family_id product_family_id,
12381: mapt.offset_type
12382: FROM msc_atp_peg_temp mapt,
12383: msc_supplies s
12384: WHERE mapt.plan_id = :p_plan_id
12385: AND mapt.relief_type = 3
12386:
12387: AND s.sr_instance_id = mapt.sr_instance_id

Line 12623: msc_supplies s

12619: :p_sysdate,
12620: mapt.customer_id,
12621: mapt.customer_site_id
12622: FROM msc_atp_peg_temp mapt,
12623: msc_supplies s
12624: WHERE mapt.plan_id = :p_plan_id
12625: AND mapt.relief_type = 3
12626:
12627: AND s.sr_instance_id = mapt.sr_instance_id