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

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

1684: l_mem_stealing_rec_date := p_ship_date;
1685: END IF;
1686:
1687: --bug3555084 using returning clause in place of select
1688: --SELECT msc_supplies_s.nextval into p_transaction_id from dual;
1689:
1690: IF p_mem_stealing_quantity > 0 THEN
1691: IF PG_DEBUG in ('Y', 'C') THEN
1692: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');

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

1704: )
1705: VALUES
1706: (p_plan_id, p_mem_item_id, p_organization_id,
1707: p_sr_instance_id, p_stealing_demand_class, l_mem_stealing_rec_date,
1708: --bug3555084 using msc_supplies_s.nextval in place of p_transaction_id
1709: msc_supplies_s.nextval, p_mem_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1710: p_mem_stealing_quantity, p_mem_item_id, 46,
1711: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_ato_model_line_id, p_refresh_number,
1712: --bug3684383

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

1705: VALUES
1706: (p_plan_id, p_mem_item_id, p_organization_id,
1707: p_sr_instance_id, p_stealing_demand_class, l_mem_stealing_rec_date,
1708: --bug3555084 using msc_supplies_s.nextval in place of p_transaction_id
1709: msc_supplies_s.nextval, p_mem_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1710: p_mem_stealing_quantity, p_mem_item_id, 46,
1711: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_ato_model_line_id, p_refresh_number,
1712: --bug3684383
1713: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID) -- For summary enhancement

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

1777: order_number,customer_id,ship_to_site_id)
1778: VALUES
1779: (p_plan_id, p_pf_item_id, p_organization_id,
1780: p_sr_instance_id, p_stealing_demand_class, l_pf_stealing_rec_date,
1781: msc_supplies_s.nextval, p_pf_stealing_quantity, 50, p_identifier,p_demand_source_type, 1,--cmro
1782: p_pf_stealing_quantity, p_mem_item_id, 46,
1783: G_USER_ID, l_sysdate, G_USER_ID, l_sysdate, p_stolen_demand_class, p_refresh_number, -- For summary enhancement
1784: --bug3684383
1785: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID)

Line 2310: MSC_SUPPLIES S,

2306:
2307: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2308: -- NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) )SD_QTY
2309: FROM MSC_CALENDAR_DATES C,
2310: MSC_SUPPLIES S,
2311: MSC_ATP_RULES R,
2312: MSC_SYSTEM_ITEMS I,
2313: MSC_SUB_INVENTORIES MSI
2314: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id

Line 2940: MSC_SUPPLIES S,

2936: l_null_char, --bug3814584
2937: l_null_char, --bug3814584
2938: l_null_date --bug3814584
2939: FROM MSC_CALENDAR_DATES C,
2940: MSC_SUPPLIES S,
2941: MSC_ATP_RULES R,
2942: MSC_SYSTEM_ITEMS I,
2943: MSC_SUB_INVENTORIES MSI
2944: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id

Line 10292: msc_supplies s

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

Line 10445: msc_supplies s,

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

Line 10662: msc_supplies s,

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

Line 10749: from msc_supplies s,

10745: :l_user_id,
10746: :l_sysdate,
10747: :l_user_id,
10748: :l_sysdate
10749: from msc_supplies s,
10750: msc_system_items i
10751: where i.aggregate_time_fence_date is not null
10752: and i.bom_item_type <> 5
10753: and i.plan_id = :p_plan_id

Line 10966: msc_supplies s,

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

Line 11133: msc_supplies s,

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

Line 11320: msc_supplies s,

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

Line 11574: msc_supplies s,

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

Line 11762: msc_supplies s,

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

Line 11862: msc_supplies s,

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

Line 11945: from msc_supplies s,

11941: :l_user_id,
11942: :l_sysdate,
11943: :l_user_id,
11944: :l_sysdate
11945: from msc_supplies s,
11946: msc_system_items i
11947: where i.aggregate_time_fence_date is not null
11948: and i.bom_item_type <> 5
11949: and i.plan_id = :p_plan_id

Line 12071: FROM msc_supplies s,

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

Line 12354: msc_supplies s

12350: mapt.end_pegging_id end_pegging_id,
12351: mapt.atf_date atf_date,
12352: mapt.product_family_id product_family_id
12353: FROM msc_atp_peg_temp mapt,
12354: msc_supplies s
12355: WHERE mapt.plan_id = :p_plan_id
12356: AND mapt.relief_type = 3
12357:
12358: AND s.sr_instance_id = mapt.sr_instance_id

Line 12592: msc_supplies s

12588: :p_sysdate,
12589: mapt.customer_id,
12590: mapt.customer_site_id
12591: FROM msc_atp_peg_temp mapt,
12592: msc_supplies s
12593: WHERE mapt.plan_id = :p_plan_id
12594: AND mapt.relief_type = 3
12595:
12596: AND s.sr_instance_id = mapt.sr_instance_id