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.JTY_TAE_CONTROL_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 481: INSERT INTO jty_terr_values_idx_details (

477: END IF; /* end IF l_exist_qual_detail_count = 0 */
478:
479: IF (l_no_of_records = 0) THEN
480: IF (q_detail.comparison_operator IS NOT NULL) THEN
481: INSERT INTO jty_terr_values_idx_details (
482: terr_values_idx_details_id
483: ,terr_values_idx_header_id
484: ,last_update_date
485: ,last_updated_by

Line 493: jty_terr_values_idx_details_s.nextval

489: ,values_col_map
490: ,input_selectivity
491: ,input_ordinal_selectivity )
492: VALUES (
493: jty_terr_values_idx_details_s.nextval
494: ,l_header_seq
495: ,G_SYSDATE
496: ,G_USER_ID
497: ,G_SYSDATE

Line 506: INSERT INTO jty_terr_values_idx_details (

502: ,null);
503: END IF;
504:
505: IF (q_detail.low_value_char_id IS NOT NULL) THEN
506: INSERT INTO jty_terr_values_idx_details (
507: terr_values_idx_details_id
508: ,terr_values_idx_header_id
509: ,last_update_date
510: ,last_updated_by

Line 518: jty_terr_values_idx_details_s.nextval

514: ,values_col_map
515: ,input_selectivity
516: ,input_ordinal_selectivity )
517: VALUES (
518: jty_terr_values_idx_details_s.nextval
519: ,l_header_seq
520: ,G_SYSDATE
521: ,G_USER_ID
522: ,G_SYSDATE

Line 531: INSERT INTO jty_terr_values_idx_details (

527: ,null);
528: END IF;
529:
530: IF (q_detail.low_value_char IS NOT NULL) THEN
531: INSERT INTO jty_terr_values_idx_details (
532: terr_values_idx_details_id
533: ,terr_values_idx_header_id
534: ,last_update_date
535: ,last_updated_by

Line 543: jty_terr_values_idx_details_s.nextval

539: ,values_col_map
540: ,input_selectivity
541: ,input_ordinal_selectivity )
542: VALUES (
543: jty_terr_values_idx_details_s.nextval
544: ,l_header_seq
545: ,G_SYSDATE
546: ,G_USER_ID
547: ,G_SYSDATE

Line 556: INSERT INTO jty_terr_values_idx_details (

552: ,null);
553: END IF;
554:
555: IF (q_detail.high_value_char IS NOT NULL) THEN
556: INSERT INTO jty_terr_values_idx_details (
557: terr_values_idx_details_id
558: ,terr_values_idx_header_id
559: ,last_update_date
560: ,last_updated_by

Line 568: jty_terr_values_idx_details_s.nextval

564: ,values_col_map
565: ,input_selectivity
566: ,input_ordinal_selectivity )
567: VALUES (
568: jty_terr_values_idx_details_s.nextval
569: ,l_header_seq
570: ,G_SYSDATE
571: ,G_USER_ID
572: ,G_SYSDATE

Line 581: INSERT INTO jty_terr_values_idx_details (

577: ,null);
578: END IF;
579:
580: IF (q_detail.low_value_number IS NOT NULL) THEN
581: INSERT INTO jty_terr_values_idx_details (
582: terr_values_idx_details_id
583: ,terr_values_idx_header_id
584: ,last_update_date
585: ,last_updated_by

Line 593: jty_terr_values_idx_details_s.nextval

589: ,values_col_map
590: ,input_selectivity
591: ,input_ordinal_selectivity )
592: VALUES (
593: jty_terr_values_idx_details_s.nextval
594: ,l_header_seq
595: ,G_SYSDATE
596: ,G_USER_ID
597: ,G_SYSDATE

Line 606: INSERT INTO jty_terr_values_idx_details (

602: ,null);
603: END IF;
604:
605: IF (q_detail.high_value_number IS NOT NULL) THEN
606: INSERT INTO jty_terr_values_idx_details (
607: terr_values_idx_details_id
608: ,terr_values_idx_header_id
609: ,last_update_date
610: ,last_updated_by

Line 618: jty_terr_values_idx_details_s.nextval

614: ,values_col_map
615: ,input_selectivity
616: ,input_ordinal_selectivity )
617: VALUES (
618: jty_terr_values_idx_details_s.nextval
619: ,l_header_seq
620: ,G_SYSDATE
621: ,G_USER_ID
622: ,G_SYSDATE

Line 631: INSERT INTO jty_terr_values_idx_details (

627: ,null);
628: END IF;
629:
630: IF (q_detail.interest_type_id IS NOT NULL) THEN
631: INSERT INTO jty_terr_values_idx_details (
632: terr_values_idx_details_id
633: ,terr_values_idx_header_id
634: ,last_update_date
635: ,last_updated_by

Line 643: jty_terr_values_idx_details_s.nextval

639: ,values_col_map
640: ,input_selectivity
641: ,input_ordinal_selectivity )
642: VALUES (
643: jty_terr_values_idx_details_s.nextval
644: ,l_header_seq
645: ,G_SYSDATE
646: ,G_USER_ID
647: ,G_SYSDATE

Line 656: INSERT INTO jty_terr_values_idx_details (

652: ,null);
653: END IF;
654:
655: IF (q_detail.primary_interest_code_id IS NOT NULL) THEN
656: INSERT INTO jty_terr_values_idx_details (
657: terr_values_idx_details_id
658: ,terr_values_idx_header_id
659: ,last_update_date
660: ,last_updated_by

Line 668: jty_terr_values_idx_details_s.nextval

664: ,values_col_map
665: ,input_selectivity
666: ,input_ordinal_selectivity )
667: VALUES (
668: jty_terr_values_idx_details_s.nextval
669: ,l_header_seq
670: ,G_SYSDATE
671: ,G_USER_ID
672: ,G_SYSDATE

Line 681: INSERT INTO jty_terr_values_idx_details (

677: ,null);
678: END IF;
679:
680: IF (q_detail.secondary_interest_code_id IS NOT NULL) THEN
681: INSERT INTO jty_terr_values_idx_details (
682: terr_values_idx_details_id
683: ,terr_values_idx_header_id
684: ,last_update_date
685: ,last_updated_by

Line 693: jty_terr_values_idx_details_s.nextval

689: ,values_col_map
690: ,input_selectivity
691: ,input_ordinal_selectivity )
692: VALUES (
693: jty_terr_values_idx_details_s.nextval
694: ,l_header_seq
695: ,G_SYSDATE
696: ,G_USER_ID
697: ,G_SYSDATE

Line 706: INSERT INTO jty_terr_values_idx_details (

702: ,null);
703: END IF;
704:
705: IF (q_detail.currency_code IS NOT NULL) THEN
706: INSERT INTO jty_terr_values_idx_details (
707: terr_values_idx_details_id
708: ,terr_values_idx_header_id
709: ,last_update_date
710: ,last_updated_by

Line 718: jty_terr_values_idx_details_s.nextval

714: ,values_col_map
715: ,input_selectivity
716: ,input_ordinal_selectivity )
717: VALUES (
718: jty_terr_values_idx_details_s.nextval
719: ,l_header_seq
720: ,G_SYSDATE
721: ,G_USER_ID
722: ,G_SYSDATE

Line 731: INSERT INTO jty_terr_values_idx_details (

727: ,null);
728: END IF;
729:
730: IF (q_detail.value1_id IS NOT NULL) THEN
731: INSERT INTO jty_terr_values_idx_details (
732: terr_values_idx_details_id
733: ,terr_values_idx_header_id
734: ,last_update_date
735: ,last_updated_by

Line 743: jty_terr_values_idx_details_s.nextval

739: ,values_col_map
740: ,input_selectivity
741: ,input_ordinal_selectivity )
742: VALUES (
743: jty_terr_values_idx_details_s.nextval
744: ,l_header_seq
745: ,G_SYSDATE
746: ,G_USER_ID
747: ,G_SYSDATE

Line 756: INSERT INTO jty_terr_values_idx_details (

752: ,null);
753: END IF;
754:
755: IF (q_detail.value2_id IS NOT NULL) THEN
756: INSERT INTO jty_terr_values_idx_details (
757: terr_values_idx_details_id
758: ,terr_values_idx_header_id
759: ,last_update_date
760: ,last_updated_by

Line 768: jty_terr_values_idx_details_s.nextval

764: ,values_col_map
765: ,input_selectivity
766: ,input_ordinal_selectivity )
767: VALUES (
768: jty_terr_values_idx_details_s.nextval
769: ,l_header_seq
770: ,G_SYSDATE
771: ,G_USER_ID
772: ,G_SYSDATE

Line 781: INSERT INTO jty_terr_values_idx_details (

777: ,null);
778: END IF;
779:
780: IF (q_detail.value3_id IS NOT NULL) THEN
781: INSERT INTO jty_terr_values_idx_details (
782: terr_values_idx_details_id
783: ,terr_values_idx_header_id
784: ,last_update_date
785: ,last_updated_by

Line 793: jty_terr_values_idx_details_s.nextval

789: ,values_col_map
790: ,input_selectivity
791: ,input_ordinal_selectivity )
792: VALUES (
793: jty_terr_values_idx_details_s.nextval
794: ,l_header_seq
795: ,G_SYSDATE
796: ,G_USER_ID
797: ,G_SYSDATE

Line 806: INSERT INTO jty_terr_values_idx_details (

802: ,null);
803: END IF;
804:
805: IF (q_detail.value4_id IS NOT NULL) THEN
806: INSERT INTO jty_terr_values_idx_details (
807: terr_values_idx_details_id
808: ,terr_values_idx_header_id
809: ,last_update_date
810: ,last_updated_by

Line 818: jty_terr_values_idx_details_s.nextval

814: ,values_col_map
815: ,input_selectivity
816: ,input_ordinal_selectivity )
817: VALUES (
818: jty_terr_values_idx_details_s.nextval
819: ,l_header_seq
820: ,G_SYSDATE
821: ,G_USER_ID
822: ,G_SYSDATE

Line 831: INSERT INTO jty_terr_values_idx_details (

827: ,null);
828: END IF;
829:
830: IF (q_detail.first_char IS NOT NULL) THEN
831: INSERT INTO jty_terr_values_idx_details (
832: terr_values_idx_details_id
833: ,terr_values_idx_header_id
834: ,last_update_date
835: ,last_updated_by

Line 843: jty_terr_values_idx_details_s.nextval

839: ,values_col_map
840: ,input_selectivity
841: ,input_ordinal_selectivity )
842: VALUES (
843: jty_terr_values_idx_details_s.nextval
844: ,l_header_seq
845: ,G_SYSDATE
846: ,G_USER_ID
847: ,G_SYSDATE

Line 1803: jty_terr_values_idx_details B

1799:
1800: CURSOR all_sets(cl_source_id number) is
1801: SELECT A.terr_values_idx_header_id, count(*) num_components
1802: FROM jty_terr_values_idx_header A,
1803: jty_terr_values_idx_details B
1804: WHERE A.source_id = cl_source_id
1805: AND A.build_index_flag = 'Y'
1806: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id
1807: AND B.values_col_map is not null

Line 1817: jty_terr_values_idx_details B

1813: , cl_terr_values_idx_header_id IN NUMBER) is
1814: SELECT * FROM (
1815: SELECT A.terr_values_idx_header_id, count(*) num_components
1816: FROM jty_terr_values_idx_header A,
1817: jty_terr_values_idx_details B
1818: WHERE A.source_id = cl_source_id
1819: AND A.terr_values_idx_header_id <> cl_terr_values_idx_header_id
1820: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id
1821: AND B.values_col_map is not null

Line 1860: FROM jty_terr_values_idx_details B

1856: FROM (
1857: SELECT rownum row_count, values_col_map, input_selectivity
1858: FROM (
1859: SELECT B.values_col_map, B.input_selectivity
1860: FROM jty_terr_values_idx_details B
1861: WHERE B.terr_values_idx_header_id = cl_set_S.terr_values_idx_header_id
1862: AND B.values_col_map IS NOT NULL
1863: ORDER BY B.input_selectivity )) S,
1864: (

Line 1868: FROM jty_terr_values_idx_details B

1864: (
1865: SELECT rownum row_count, values_col_map, input_selectivity
1866: FROM (
1867: SELECT B.values_col_map, B.input_selectivity
1868: FROM jty_terr_values_idx_details B
1869: WHERE B.terr_values_idx_header_id = cl_set_L.terr_values_idx_header_id
1870: AND B.values_col_map IS NOT NULL
1871: ORDER BY B.input_selectivity )) L
1872: WHERE S.values_col_map = L.values_col_map