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.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_PRODUCTS_V

Line 551: from jtf_rs_products_v a

547:
548: IF (p_range_high < 0) THEN
549: SELECT count(*)
550: INTO l_total_count
551: from jtf_rs_products_v a
552: where UPPER(a.PRODUCT_NAME) like l_display_value
553: and nvl(a.enabled_flag, 'Y') <> 'N'
554: and a.PRODUCT_ORG_ID = l_org_id;
555:

Line 570: from jtf_rs_products_v a

566: END IF;
567:
568: OPEN lov_output_cur FOR
569: select a.PRODUCT_NAME, to_char(a.PRODUCT_ID), null, a.DESCRIPTION, null, null, null, null, null, null
570: from jtf_rs_products_v a
571: where UPPER(a.PRODUCT_NAME) like l_display_value
572: and nvl(a.enabled_flag, 'Y') <> 'N'
573: and a.PRODUCT_ORG_ID = l_org_id
574: order by a.PRODUCT_NAME;

Line 581: from jtf_rs_products_v a

577: -- Get the total count if "Last" hyperlink is clicked
578: IF (p_range_high < 0) THEN
579: SELECT count(*)
580: INTO l_total_count
581: from jtf_rs_products_v a
582: where UPPER(PRODUCT_NAME) like l_display_value
583: and PRODUCT_ORG_ID = l_org_id
584: and nvl(a.enabled_flag, 'Y') <> 'N'
585: and exists(select null from mtl_item_categories c

Line 603: from jtf_rs_products_v a

599:
600: END IF;
601: OPEN lov_output_cur FOR
602: select a.PRODUCT_NAME, to_char(a.PRODUCT_ID), null, a.DESCRIPTION, null, null, null, null, null, null
603: from jtf_rs_products_v a
604: where UPPER(a.PRODUCT_NAME) like l_display_value
605: and a.PRODUCT_ORG_ID = l_org_id
606: and nvl(a.enabled_flag, 'Y') <> 'N'
607: and exists(select null from mtl_item_categories c