DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_USGS_ALL

Line 407: FROM jtf_qual_usgs_all jqu

403: , lp_qual_type_id NUMBER
404: , lp_sysdate DATE ) IS
405:
406: SELECT jqu.qual_usg_id, jqu.rule1
407: FROM jtf_qual_usgs_all jqu
408: , jtf_qual_type_usgs jqtu
409: , jtf_qual_type_denorm_v v
410: WHERE --jqu.enabled_flag = 'Y'
411: jqu.org_id = -3113

Line 432: FROM jtf_qual_usgs_all jqu

428: AND jtq.qual_usg_id = jqu.qual_usg_id )
429: UNION
430:
431: SELECT jqu.qual_usg_id, jqu.rule2
432: FROM jtf_qual_usgs_all jqu
433: , jtf_qual_type_usgs_all jqtu
434: , jtf_qual_type_denorm_v v
435: WHERE --jqu.enabled_flag = 'Y'
436: jqu.org_id = -3113