APPS.JTF_TAE_GEN_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 997: jtf_tae_qual_products jtqp,

993: ,jqu.op_not_between
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

Line 1147: jtf_tae_qual_products jtqp,

1143: ,jqu.op_not_between
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

Line 1639: jtf_tae_qual_products jtqp,

1635: ,jqu.op_not_between
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

Line 3339: FROM jtf_tae_qual_products jtqp

3335: CURSOR c_rel_prod( lp_source_id NUMBER
3336: , lp_qual_type_id NUMBER)
3337: IS
3338: SELECT DISTINCT jtqp.relation_product
3339: FROM jtf_tae_qual_products jtqp
3340: WHERE jtqp.source_id = lp_source_id
3341: AND jtqp.trans_object_type_id= lp_qual_type_id
3342: ORDER BY jtqp.relation_product DESC;
3343:

Line 3420: Add_To_PackageTable (' FROM jtf_tae_qual_products jtqp ');

3416: Add_To_PackageTable (' i NUMBER:=0; ');
3417: Add_To_PackageTable (' ');
3418: Add_To_PackageTable (' CURSOR c_get_qualrel_prod IS ');
3419: Add_To_PackageTable (' SELECT jtqp.relation_product ');
3420: Add_To_PackageTable (' FROM jtf_tae_qual_products jtqp ');
3421: Add_To_PackageTable (' WHERE jtqp.source_id = p_source_id ');
3422: Add_To_PackageTable (' AND jtqp.trans_object_type_id = p_trans_object_type_id');
3423: Add_To_PackageTable (' ORDER BY jtqp.relation_product DESC ;');
3424: Add_To_PackageTable (' ');

Line 3851: FROM jtf_tae_qual_products jtqp

3847: BEGIN
3848:
3849: SELECT COUNT(*)
3850: INTO num_of_combination
3851: FROM jtf_tae_qual_products jtqp
3852: WHERE jtqp.source_id = p_source_id
3853: AND jtqp.trans_object_type_id = p_trans_object_type_id;
3854:
3855: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

Line 4114: FROM jtf_tae_qual_products jtqp

4110: BEGIN
4111:
4112: SELECT COUNT(*)
4113: INTO num_of_combination
4114: FROM jtf_tae_qual_products jtqp
4115: WHERE jtqp.source_id = p_source_id
4116: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4117:
4118: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

Line 4350: FROM jtf_tae_qual_products jtqp

4346: BEGIN
4347:
4348: SELECT COUNT(*)
4349: INTO num_of_combination
4350: FROM jtf_tae_qual_products jtqp
4351: WHERE jtqp.source_id = p_source_id
4352: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4353:
4354: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

Line 4645: FROM jtf_tae_qual_products jtqp

4641: BEGIN
4642:
4643: SELECT COUNT(*)
4644: INTO num_of_combination
4645: FROM jtf_tae_qual_products jtqp
4646: WHERE jtqp.source_id = p_source_id
4647: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4648:
4649: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);