DBA Data[Home] [Help]

APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_COMPONENTS_V

Line 736: from jtf_rs_components_v a

732: else
733: IF (p_range_high < 0) THEN
734: SELECT count(*)
735: INTO l_total_count
736: from jtf_rs_components_v a
737: where UPPER(a.COMPONENT_NAME) like l_display_value
738: and a.product_org_id = l_org_id
739: and a.product_id = l_aux_value1;
740:

Line 755: from jtf_rs_components_v a

751: END IF;
752:
753: OPEN lov_output_cur FOR
754: select a.COMPONENT_NAME, to_char(a.COMPONENT_ID), to_char(a.product_id), a.DESCRIPTION, null, null, null, null, null, null
755: from jtf_rs_components_v a
756: where UPPER(a.COMPONENT_NAME) like l_display_value
757: and a.product_id = l_aux_value1
758: and a.product_org_id = l_org_id
759: order by a.COMPONENT_NAME;