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 2077: from msc_system_items itm,

2073: Select DECODE(pl.planning_time_fence_flag,
2074: 1, trunc(NVL(itm.planning_time_fence_date, l_sysdate)),
2075: l_sysdate),pl.planning_time_fence_flag -- Bug 3578083
2076: into l_ptf_date,l_ptf_enabled -- Bug 3578083
2077: from msc_system_items itm,
2078: msc_plans pl
2079: where itm.plan_id = org_availability_info.plan_id(l_parent_org_cntr)
2080: and itm.sr_instance_id = p_atp_record.instance_id
2081: and itm.organization_id = org_availability_info.organization_id(l_parent_org_cntr)

Line 4958: msc_system_items msi1,

4954: p_item_table.atf_date,
4955: p_item_table.atf_date_quantity
4956: -- time_phased_atp changes end
4957: FROM msc_item_substitutes mis,
4958: msc_system_items msi1,
4959: msc_system_items msi2
4960: WHERE mis.plan_id = p_plan_id
4961: AND mis.sr_instance_id = p_instance_id
4962: AND mis.lower_item_id = p_inventory_item_id

Line 4959: msc_system_items msi2

4955: p_item_table.atf_date_quantity
4956: -- time_phased_atp changes end
4957: FROM msc_item_substitutes mis,
4958: msc_system_items msi1,
4959: msc_system_items msi2
4960: WHERE mis.plan_id = p_plan_id
4961: AND mis.sr_instance_id = p_instance_id
4962: AND mis.lower_item_id = p_inventory_item_id
4963: AND mis.effective_date <= l_request_date

Line 5047: msc_system_items msi1,

5043: p_item_table.atf_date,
5044: p_item_table.atf_date_quantity
5045: -- time_phased_atp changes end
5046: FROM msc_item_substitutes mis,
5047: msc_system_items msi1,
5048: msc_system_items msi2
5049: WHERE mis.plan_id = p_plan_id
5050: AND mis.sr_instance_id = p_instance_id
5051: AND mis.lower_item_id = p_inventory_item_id

Line 5048: msc_system_items msi2

5044: p_item_table.atf_date_quantity
5045: -- time_phased_atp changes end
5046: FROM msc_item_substitutes mis,
5047: msc_system_items msi1,
5048: msc_system_items msi2
5049: WHERE mis.plan_id = p_plan_id
5050: AND mis.sr_instance_id = p_instance_id
5051: AND mis.lower_item_id = p_inventory_item_id
5052: AND mis.effective_date <= l_request_date

Line 5149: msc_system_items msi1,

5145: ,p_item_table.family_item_name
5146: ,p_item_table.atf_date
5147: ,p_item_table.atf_date_quantity
5148: FROM msc_item_substitutes mis,
5149: msc_system_items msi1,
5150: msc_system_items msi2
5151: WHERE mis.plan_id = p_plan_id
5152: AND mis.sr_instance_id = p_instance_id
5153: AND mis.lower_item_id = p_inventory_item_id

Line 5150: msc_system_items msi2

5146: ,p_item_table.atf_date
5147: ,p_item_table.atf_date_quantity
5148: FROM msc_item_substitutes mis,
5149: msc_system_items msi1,
5150: msc_system_items msi2
5151: WHERE mis.plan_id = p_plan_id
5152: AND mis.sr_instance_id = p_instance_id
5153: AND mis.lower_item_id = p_inventory_item_id
5154: AND mis.effective_date <= l_request_date