APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_PROBLEM_CODES_V

Line 690: from jtf_rs_problem_codes_v

686: -- Get the total count if "Last" hyperlink is clicked
687: IF (p_range_high < 0) THEN
688: SELECT count(*)
689: INTO l_total_count
690: from jtf_rs_problem_codes_v
691: where UPPER(PROBLEM_NAME) like l_display_value
692: AND enabled_flag = 'Y'
693: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
694: nvl(end_date_active, sysdate);

Line 710: from jtf_rs_problem_codes_v a

706: END IF;
707:
708: OPEN lov_output_cur FOR
709: select a.PROBLEM_NAME, a.PROBLEM_CODE, a.DESCRIPTION, null,null, null, null, null, null, null
710: from jtf_rs_problem_codes_v a
711: where UPPER(a.PROBLEM_NAME) like l_display_value
712: AND a.enabled_flag = 'Y'
713: AND trunc(sysdate) between trunc(nvl(a.start_date_active, sysdate)) and
714: nvl(a.end_date_active, sysdate)

Line 780: ' from cs_sr_prob_code_mapping a, jtf_rs_problem_codes_v b '||

776: else
777: IF (p_range_high < 0) THEN
778: EXECUTE IMMEDIATE
779: ' SELECT count(*) '||
780: ' from cs_sr_prob_code_mapping a, jtf_rs_problem_codes_v b '||
781: ' where UPPER(b.PROBLEM_NAME) like :1 '||
782: ' and nvl(b.enabled_flag, ''Y'') <> ''N'' '||
783: ' and a.ORGANIZATION_ID = :2 '||
784: ' and a.inventory_item_id = :3 '||

Line 802: ' from cs_sr_prob_code_mapping a, jtf_rs_problem_codes_v b '||

798:
799: END IF;
800: OPEN lov_output_cur FOR
801: ' select b.PROBLEM_NAME, a.PROBLEM_CODE, to_char(a.inventory_item_id), b.DESCRIPTION, null, null, null, null, null, null ' ||
802: ' from cs_sr_prob_code_mapping a, jtf_rs_problem_codes_v b '||
803: ' where UPPER(b.PROBLEM_NAME) like :1 '||
804: ' and nvl(b.enabled_flag, ''Y'') <> ''N'' '||
805: ' and a.ORGANIZATION_ID = :2 '||
806: ' and a.inventory_item_id = :3 '||