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_SYSTEM_ITEMS

Line 2100: from msc_system_items itm,

2096: Select DECODE(pl.planning_time_fence_flag,
2097: 1, trunc(NVL(itm.planning_time_fence_date, l_sysdate)),
2098: l_sysdate),pl.planning_time_fence_flag -- Bug 3578083
2099: into l_ptf_date,l_ptf_enabled -- Bug 3578083
2100: from msc_system_items itm,
2101: msc_plans pl
2102: where itm.plan_id = org_availability_info.plan_id(l_parent_org_cntr)
2103: and itm.sr_instance_id = p_atp_record.instance_id
2104: and itm.organization_id = org_availability_info.organization_id(l_parent_org_cntr)

Line 5117: msc_system_items msi1,

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
5121: AND mis.lower_item_id = p_inventory_item_id

Line 5118: msc_system_items msi2

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
5121: AND mis.lower_item_id = p_inventory_item_id
5122: AND mis.effective_date <= l_request_date

Line 5203: msc_system_items msi1,

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
5207: AND mis.lower_item_id = p_inventory_item_id

Line 5204: msc_system_items msi2

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
5207: AND mis.lower_item_id = p_inventory_item_id
5208: AND mis.effective_date <= l_request_date

Line 5302: msc_system_items msi1,

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
5306: AND mis.lower_item_id = p_inventory_item_id

Line 5303: msc_system_items msi2

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
5306: AND mis.lower_item_id = p_inventory_item_id
5307: AND mis.effective_date <= l_request_date

Line 5372: msc_system_items msi1,

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
5376: AND mis.lower_item_id = p_inventory_item_id

Line 5373: msc_system_items msi2

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
5376: AND mis.lower_item_id = p_inventory_item_id
5377: AND mis.effective_date <= l_request_date