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_SUBST dependencies on MSC_ITEM_SUBSTITUTES

Line 5026: Get count of records from msc_item_substitutes for cust_site specific rule in l_count

5022: /*-----------------------------------------------------
5023: Changed substitution rule picking logic as a part of GOP Web Service:
5024:
5025: If customer_id is not null then
5026: Get count of records from msc_item_substitutes for cust_site specific rule in l_count
5027: If l_count = 0 then
5028: Get count of records from msc_item_substitutes for cust specific rule in l_count_no_site
5029: End if;
5030:

Line 5028: Get count of records from msc_item_substitutes for cust specific rule in l_count_no_site

5024:
5025: If customer_id is not null then
5026: Get count of records from msc_item_substitutes for cust_site specific rule in l_count
5027: If l_count = 0 then
5028: Get count of records from msc_item_substitutes for cust specific rule in l_count_no_site
5029: End if;
5030:
5031: If l_count > 0 then
5032: Process for site rule

Line 5047: FROM msc_item_substitutes mis

5043:
5044: IF l_customer_id is not null THEN
5045: SELECT count(*)
5046: INTO l_count
5047: FROM msc_item_substitutes mis
5048: WHERE mis.plan_id = p_plan_id
5049: AND mis.sr_instance_id = p_instance_id
5050: ---bug 2341179 : inferred_flag is used for UI purpose only
5051: --AND mis.inferred_flag = 2

Line 5058: FROM msc_item_substitutes mis

5054:
5055: IF l_count = 0 then
5056: SELECT count(*)
5057: INTO l_count_no_site
5058: FROM msc_item_substitutes mis
5059: WHERE mis.plan_id = p_plan_id
5060: AND mis.sr_instance_id = p_instance_id
5061: AND mis.customer_id = l_customer_id
5062: AND NVL(mis.customer_site_id, -1) = -1;

Line 5116: FROM msc_item_substitutes mis,

5112: p_item_table.family_item_name,
5113: p_item_table.atf_date,
5114: p_item_table.atf_date_quantity
5115: -- time_phased_atp changes end
5116: FROM msc_item_substitutes mis,
5117: msc_system_items msi1,
5118: msc_system_items msi2
5119: WHERE mis.plan_id = p_plan_id
5120: AND mis.sr_instance_id = p_instance_id

Line 5202: FROM msc_item_substitutes mis,

5198: p_item_table.family_dest_id,
5199: p_item_table.family_item_name,
5200: p_item_table.atf_date,
5201: p_item_table.atf_date_quantity
5202: FROM msc_item_substitutes mis,
5203: msc_system_items msi1,
5204: msc_system_items msi2
5205: WHERE mis.plan_id = p_plan_id
5206: AND mis.sr_instance_id = p_instance_id

Line 5301: FROM msc_item_substitutes mis,

5297: ,p_item_table.family_dest_id
5298: ,p_item_table.family_item_name
5299: ,p_item_table.atf_date
5300: ,p_item_table.atf_date_quantity
5301: FROM msc_item_substitutes mis,
5302: msc_system_items msi1,
5303: msc_system_items msi2
5304: WHERE mis.plan_id = p_plan_id
5305: AND mis.sr_instance_id = p_instance_id

Line 5371: FROM msc_item_substitutes mis,

5367: p_item_table.family_item_name,
5368: p_item_table.atf_date,
5369: p_item_table.atf_date_quantity
5370: -- time_phased_atp changes end
5371: FROM msc_item_substitutes mis,
5372: msc_system_items msi1,
5373: msc_system_items msi2
5374: WHERE mis.plan_id = p_plan_id
5375: AND mis.sr_instance_id = p_instance_id