344: ,jqu.op_common_where
345: FROM jtf_qual_usgs_all jqu,
346: jtf_tae_qual_factors jtqf,
347: jtf_tae_qual_products jtqp,
348: jtf_tae_qual_prod_factors jtpf
349: WHERE jqu.org_id = -3113
350: AND jqu.qual_usg_id = jtqf.qual_usg_id
351: AND jtpf.qual_factor_id = jtqf.qual_factor_id
352: AND jtqf.relation_factor = cl_relation_factor
557: FROM
558: jtf_qual_usgs_all jqu
559: ,jtf_tae_qual_factors jtqf
560: ,jtf_tae_qual_products jtqp
561: ,jtf_tae_qual_prod_factors jtpf
562: WHERE jqu.org_id = -3113
563: AND jqu.qual_usg_id = jtqf.qual_usg_id
564: AND jtpf.qual_factor_id= jtqf.qual_factor_id
565: AND jtqf.relation_factor <> cl_relation_factor
759: FROM
760: jtf_qual_usgs_all jqu
761: ,jtf_tae_qual_factors jtqf
762: ,jtf_tae_qual_products jtqp
763: ,jtf_tae_qual_prod_factors jtpf
764: WHERE jqu.org_id = -3113
765: AND jqu.qual_usg_id = jtqf.qual_usg_id
766: AND jtpf.qual_factor_id= jtqf.qual_factor_id
767: AND jtqf.relation_factor <> cl_relation_factor