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

Line 1562: from msc_item_substitutes

1558: (select distinct lower_item_id,
1559: first_value(highest_item_id) over(partition by lower_item_id) highest_item_id
1560: from
1561: (select lower_item_id, highest_item_id
1562: from msc_item_substitutes
1563: where plan_id=p_plan_id
1564: and relationship_type=8
1565: and inferred_flag=2
1566: and forward_rule=1

Line 1570: from msc_item_substitutes

1566: and forward_rule=1
1567: and sysdate between effective_date and nvl(disable_date, sysdate)
1568: union
1569: select highest_item_id, highest_item_id
1570: from msc_item_substitutes
1571: where plan_id=p_plan_id
1572: and relationship_type=8
1573: and inferred_flag=2
1574: and forward_rule=1