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_PRODUCTS

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 224: ** JTF_TAE_QUAL_PRODUCTS NOT BEING CORRECTLY POPULATED SINCE

220: ,jtf_qual_type_usgs_all jqtu
221: WHERE 1=1
222: --and org_id = -3113
223: /* JDOCHERT: 07/29/03: BUG# :
224: ** JTF_TAE_QUAL_PRODUCTS NOT BEING CORRECTLY POPULATED SINCE
225: ** POPULATION OF jtdr.resource_exists_flag = 'Y' NOW TAKES
226: ** PLACE AT TOWARDS END OF GTP BEFORE MV REFRESH.
227: */
228: --AND resource_exists_flag = 'Y'

Line 413: ** JTF_TAE_QUAL_PRODUCTS NOT BEING CORRECTLY POPULATED SINCE

409: and ijtdr.related_terr_id = jtq.terr_id
410: and jtq.qual_usg_id = qual_rel.qual_usg_id )
411: */
412: /* JDOCHERT: 07/29/03: BUG# :
413: ** JTF_TAE_QUAL_PRODUCTS NOT BEING CORRECTLY POPULATED SINCE
414: ** POPULATION OF jtdr.resource_exists_flag = 'Y' NOW TAKES
415: ** PLACE AT TOWARDS END OF GTP BEFORE MV REFRESH.
416: */
417: --AND jtdr.resource_exists_flag = 'Y'

Line 464: (select qual_product_id from jtf_tae_qual_products

460:
461: -- CLEAR AGGREGATE/COMPONENT RELATION KEY ALGORITHM STORAGE TABLES
462: DELETE FROM jtf_tae_qual_prod_factors
463: where qual_product_id in
464: (select qual_product_id from jtf_tae_qual_products
465: where source_id = l_source_id
466: and trans_object_type_id = l_trans_id);
467:
468: delete from JTF_TAE_QUAL_products

Line 468: delete from JTF_TAE_QUAL_products

464: (select qual_product_id from jtf_tae_qual_products
465: where source_id = l_source_id
466: and trans_object_type_id = l_trans_id);
467:
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

Line 474: FROM jtf_tae_qual_products i

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:
477:
478: EXCEPTION

Line 500: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL

496: l_counter := l_counter + 1;
497:
498: l_char_tx_id := ABS(l_trans_id);
499:
500: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL
501: INTO l_qual_product_id
502: FROM dual;
503:
504: --dbms_output.put_line(' CURSOR NUMBER ' || l_counter || ' total_terr_count: ' || rel_set.total_count || ' / qual_relation_product: ' || rel_set.qual_relation_product);

Line 512: INSERT INTO JTF_TAE_QUAL_products

508: if rel_set.qual_relation_product <> 1 then
509:
510: BEGIN
511:
512: INSERT INTO JTF_TAE_QUAL_products
513: ( QUAL_PRODUCT_ID,
514: RELATION_PRODUCT,
515: SOURCE_ID,
516: TRANS_OBJECT_TYPE_ID,

Line 546: 'Populating JTF_TAE_QUAL_PRODUCTS table.';

542:
543: EXCEPTION
544: WHEN NO_DATA_FOUND THEN
545: ERRBUF := 'JTF_TAE_CONTROL.Classify_Territories: [4] NO_DATA_FOUND: ' ||
546: 'Populating JTF_TAE_QUAL_PRODUCTS table.';
547: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
548: RAISE FND_API.G_EXC_ERROR;
549:
550: WHEN OTHERS THEN

Line 771: -- JTF_TAE_QUAL_PRODUCTS

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
775: -- Sets value of BUILD_INDEX_FLAG

Line 774: -- Rows in JTF_TAE_QUAL_PRODUCTS

770: -- JTF_TAE_QUAL_FACTORS
771: -- JTF_TAE_QUAL_PRODUCTS
772: --
773: -- MODIFIES
774: -- Rows in JTF_TAE_QUAL_PRODUCTS
775: -- Sets value of BUILD_INDEX_FLAG
776: -- Sets value of FIRST_CHAR (A FLAG) ## NOT YET COMPLETED
777: --
778: -- EFFECTS

Line 804: from JTF_TAE_QUAL_products p,

800: l_trans_id NUMBER;
801:
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

Line 816: from JTF_TAE_QUAL_products p,

812: group by p.trans_object_type_id, p.qual_product_id, p.relation_product
813: order by p.relation_product;
814:
815: /* select count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
816: from JTF_TAE_QUAL_products p,
817: JTF_TAE_QUAL_prod_factors pf
818: where p.qual_product_id = pf.qual_product_id
819: group by p.qual_product_id, p.relation_product
820: order by 1;

Line 828: from JTF_TAE_QUAL_products p,

824: , cl_qual_product_id NUMBER
825: , cl_relation_product NUMBER ) is
826: select * from (
827: select count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
828: from JTF_TAE_QUAL_products p,
829: JTF_TAE_QUAL_prod_factors pf
830: where p.qual_product_id = pf.qual_product_id
831: and p.source_id = p_source_id
832: and p.trans_object_type_id = p_trans_id

Line 841: from JTF_TAE_QUAL_products p

837: order by 1 DESC, qual_product_id ASC;
838:
839: Cursor all_empty_column_indexes is
840: select p.trans_object_type_id, p.qual_product_id, p.relation_product
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

Line 843: from JTF_TAE_QUAL_products ip,

839: Cursor all_empty_column_indexes is
840: select p.trans_object_type_id, p.qual_product_id, p.relation_product
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'

Line 886: from JTF_TAE_QUAL_products p,

882: from (
883: select rownum row_count, tae_col_map, input_selectivity
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

Line 902: from JTF_TAE_QUAL_products p,

898: (
899: select rownum row_count, tae_col_map, input_selectivity
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

Line 959: UPDATE JTF_TAE_QUAL_PRODUCTS

955: end if;
956:
957: if S_subset_L = 'Y' then
958: --dbms_output.put_line(' ' || cl_set_S.relation_product || ' IS ordinal subset of ' || L_current_product);
959: UPDATE JTF_TAE_QUAL_PRODUCTS
960: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
961: WHERE qual_product_id = cl_set_S.qual_product_id
962:
963: /* JDOCHERT: 10/12/03: INDEX SHOULD ALWAYS BE BUILT

Line 971: UPDATE JTF_TAE_QUAL_PRODUCTS

967: */
968: AND RELATION_PRODUCT NOT IN (4841, 324347);
969:
970: /* ARPATEL: 10/20, still need to make sure that first_char_flag is set for 4841 and 324347 */
971: UPDATE JTF_TAE_QUAL_PRODUCTS
972: SET FIRST_CHAR_FLAG = l_first_char_flag
973: WHERE qual_product_id = cl_set_S.qual_product_id
974: AND RELATION_PRODUCT IN (4841, 324347);
975:

Line 979: UPDATE JTF_TAE_QUAL_PRODUCTS

975:
976:
977: else
978: --dbms_output.put_line(' ' || cl_set_S.relation_product || ' NOT an ordinal subset');
979: UPDATE JTF_TAE_QUAL_PRODUCTS
980: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
981: WHERE qual_product_id = cl_set_S.qual_product_id;
982:
983: end if;

Line 990: UPDATE JTF_TAE_QUAL_PRODUCTS

986: ** we need to set first_char_flag to 'Y' to ensure that reverse index
987: ** (JTF_TAE_TN1002_324347X_ND) for 324347
988: ** is created, regardless of whether 324347 territories exist.
989: */
990: UPDATE JTF_TAE_QUAL_PRODUCTS
991: SET FIRST_CHAR_FLAG = 'Y'
992: WHERE qual_product_id = cl_set_S.qual_product_id
993: AND RELATION_PRODUCT = 353393;
994:

Line 1002: update JTF_TAE_QUAL_PRODUCTS p

998: -- Set build_index_flag = 'N' for all empty column indexes combinations
999: --dbms_output.put_line('Set reduction code running ');
1000: for empty_column_index in all_empty_column_indexes loop
1001: --dbms_output.put_line('BUILD_INDEX_FLAG = ''N'' for product_id: ' || empty_column_index.qual_product_id);
1002: update JTF_TAE_QUAL_PRODUCTS p
1003: set BUILD_INDEX_FLAG = 'N'
1004: where p.qual_product_id = empty_column_index.qual_product_id;
1005: end loop;
1006:

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.