eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_TAE_QUAL_FACTORS

Line 138: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS

134: -- jtf_terr_denorm_rules_all
135: -- jtf_terr_qual_all
136: --
137: -- MODIFIES
138: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS
139: --
140: -- EFFECTS
141: -- Allows TAP to run with select statements of terr-qual relation
142: -- combinations.

Line 472: DELETE FROM jtf_tae_qual_factors o

468: delete from JTF_TAE_QUAL_products
469: where source_id = l_source_id and trans_object_type_id = l_trans_id;
470:
471: --added sbehera 04/16/2002
472: DELETE FROM jtf_tae_qual_factors o
473: WHERE NOT EXISTS ( SELECT NULL
474: FROM jtf_tae_qual_products i
475: WHERE MOD(i.relation_product, o.relation_factor) = 0 );
476:

Line 570: from JTF_TAE_QUAL_factors

566: -- there should only be one record here
567: l_qual_prod_counter := l_qual_prod_counter + 1;
568:
569: select count(*) into l_exist_qual_detail_count
570: from JTF_TAE_QUAL_factors
571: where qual_usg_id = q_detail.qual_usg_id;
572:
573: if l_exist_qual_detail_count = 0 then
574:

Line 577: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL

573: if l_exist_qual_detail_count = 0 then
574:
575: BEGIN
576:
577: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
578: INTO l_qual_factor_id
579: FROM dual;
580:
581: INSERT INTO JTF_TAE_QUAL_factors

Line 581: INSERT INTO JTF_TAE_QUAL_factors

577: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
578: INTO l_qual_factor_id
579: FROM dual;
580:
581: INSERT INTO JTF_TAE_QUAL_factors
582: ( QUAL_FACTOR_ID ,
583: RELATION_FACTOR ,
584: QUAL_USG_ID ,
585: LAST_UPDATED_BY ,

Line 631: 'Populating JTF_TAE_QUAL_FACTORS table.';

627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: ERRBUF := 'JTF_TAE_CONTROL.Classify_Territories: [5] NO_DATA_FOUND: ' ||
631: 'Populating JTF_TAE_QUAL_FACTORS table.';
632: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
633: RAISE FND_API.G_EXC_ERROR;
634:
635: WHEN OTHERS THEN

Line 655: from JTF_TAE_QUAL_factors

651: /* BUG#2990404: JDOCHERT: 09/02/03:
652: ** add rownum restriction to avoid GTP failing
653: */
654: select qual_factor_id into l_qual_factor_id
655: from JTF_TAE_QUAL_factors
656: where qual_usg_id = qual_name.qual_usg_id
657: AND rownum < 2;
658:
659: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL

Line 770: -- JTF_TAE_QUAL_FACTORS

766: -- ordinal supersets of all sets reduced.
767: --
768: --
769: -- REQIRES / DEPENDENCIES
770: -- JTF_TAE_QUAL_FACTORS
771: -- JTF_TAE_QUAL_PRODUCTS
772: --
773: -- MODIFIES
774: -- Rows in JTF_TAE_QUAL_PRODUCTS

Line 806: JTF_TAE_QUAL_factors f

802: Cursor all_sets is
803: select p.trans_object_type_id, count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
804: from JTF_TAE_QUAL_products p,
805: JTF_TAE_QUAL_prod_factors pf,
806: JTF_TAE_QUAL_factors f
807: where p.qual_product_id = pf.qual_product_id
808: and pf.qual_factor_id = f.qual_factor_id
809: and f.tae_col_map is not null
810: and p.source_id = p_source_id

Line 845: JTF_TAE_QUAL_factors ifc

841: from JTF_TAE_QUAL_products p
842: where not exists (select *
843: from JTF_TAE_QUAL_products ip,
844: JTF_TAE_QUAL_prod_factors ipf,
845: JTF_TAE_QUAL_factors ifc
846:
847: where use_tae_col_in_index_flag = 'Y'
848: and ip.qual_product_id = ipf.qual_product_id
849: and ipf.qual_factor_id = ifc.qual_factor_id

Line 888: JTF_TAE_QUAL_factors f

884: from (
885: select distinct p.relation_product, f.tae_col_map, f.input_selectivity
886: from JTF_TAE_QUAL_products p,
887: JTF_TAE_QUAL_prod_factors pf,
888: JTF_TAE_QUAL_factors f
889: where f.qual_factor_id = pf.qual_factor_id
890: and pf.qual_product_id = p.qual_product_id
891: and p.relation_product = cl_set_S.relation_product
892: and f.tae_col_map is not null

Line 904: JTF_TAE_QUAL_factors f

900: from (
901: select distinct p.relation_product, f.tae_col_map, f.input_selectivity
902: from JTF_TAE_QUAL_products p,
903: JTF_TAE_QUAL_prod_factors pf,
904: JTF_TAE_QUAL_factors f
905: where f.qual_factor_id = pf.qual_factor_id
906: and pf.qual_product_id = p.qual_product_id
907: and p.relation_product = cl_set_L.relation_product
908: and f.tae_col_map is not null

Line 937: JTF_TAE_QUAL_factors f

933: from
934: (select qual_usg_id, tae_col_map, rownum row_count
935: from ( select f.qual_usg_id, f.relation_factor, f.tae_col_map
936: from JTF_TAE_QUAL_prod_factors pf,
937: JTF_TAE_QUAL_factors f
938: where pf.qual_factor_id = f.qual_factor_id
939: and pf.qual_product_id = cl_set_S.qual_product_id
940: order by f.input_selectivity
941: )

Line 1071: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS

1067: -- REQIRES / DEPENDENCIES
1068: -- JTF_TERR_AE_CONTROL Private procedures.
1069: --
1070: -- MODIFIES
1071: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS
1072: --
1073: -- EFFECTS
1074: -- Allows TAP to run with select statements of terr-qual relation
1075: -- combinations.

Line 1199: update JTF_TAE_QUAL_factors

1195: RAISE FND_API.G_EXC_ERROR;
1196:
1197: END IF;
1198:
1199: update JTF_TAE_QUAL_factors
1200: set UPDATE_SELECTIVITY_FLAG = 'N', USE_TAE_COL_IN_INDEX_FLAG = 'N'
1201: where TAE_COL_MAP is null;
1202:
1203: end if; -- p_classify_terr_comb?