994: ,jqu.op_common_where
995: FROM jtf_qual_usgs_all jqu,
996: jtf_tae_qual_factors jtqf,
997: jtf_tae_qual_products jtqp,
998: jtf_tae_qual_prod_factors jtpf
999: WHERE jqu.org_id = -3113
1000: AND jqu.qual_usg_id = jtqf.qual_usg_id
1001: and jtpf.qual_factor_id = jtqf.qual_factor_id
1002: and jtqf.relation_factor = p_relation_factor
1144: ,jqu.op_common_where
1145: FROM jtf_qual_usgs_all jqu,
1146: jtf_tae_qual_factors jtqf,
1147: jtf_tae_qual_products jtqp,
1148: jtf_tae_qual_prod_factors jtpf
1149: WHERE jqu.org_id = -3113
1150: AND jqu.qual_usg_id = jtqf.qual_usg_id
1151: AND jtpf.qual_factor_id= jtqf.qual_factor_id
1152: AND jtqf.relation_factor <> p_relation_factor
1636: ,jqu.op_common_where
1637: FROM jtf_qual_usgs_all jqu,
1638: jtf_tae_qual_factors jtqf,
1639: jtf_tae_qual_products jtqp,
1640: jtf_tae_qual_prod_factors jtpf
1641: WHERE jqu.org_id = -3113
1642: AND jqu.qual_usg_id = jtqf.qual_usg_id
1643: and jtpf.qual_factor_id= jtqf.qual_factor_id
1644: and jtqp.qual_product_id = jtpf.qual_product_id