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 440: INSERT INTO jty_terr_values_idx_details (

436: END IF; /* end IF l_exist_qual_detail_count = 0 */
437:
438: IF (l_no_of_records = 0) THEN
439: IF (q_detail.comparison_operator IS NOT NULL) THEN
440: INSERT INTO jty_terr_values_idx_details (
441: terr_values_idx_details_id
442: ,terr_values_idx_header_id
443: ,last_update_date
444: ,last_updated_by

Line 452: jty_terr_values_idx_details_s.nextval

448: ,values_col_map
449: ,input_selectivity
450: ,input_ordinal_selectivity )
451: VALUES (
452: jty_terr_values_idx_details_s.nextval
453: ,l_header_seq
454: ,G_SYSDATE
455: ,G_USER_ID
456: ,G_SYSDATE

Line 465: INSERT INTO jty_terr_values_idx_details (

461: ,null);
462: END IF;
463:
464: IF (q_detail.low_value_char_id IS NOT NULL) THEN
465: INSERT INTO jty_terr_values_idx_details (
466: terr_values_idx_details_id
467: ,terr_values_idx_header_id
468: ,last_update_date
469: ,last_updated_by

Line 477: jty_terr_values_idx_details_s.nextval

473: ,values_col_map
474: ,input_selectivity
475: ,input_ordinal_selectivity )
476: VALUES (
477: jty_terr_values_idx_details_s.nextval
478: ,l_header_seq
479: ,G_SYSDATE
480: ,G_USER_ID
481: ,G_SYSDATE

Line 490: INSERT INTO jty_terr_values_idx_details (

486: ,null);
487: END IF;
488:
489: IF (q_detail.low_value_char IS NOT NULL) THEN
490: INSERT INTO jty_terr_values_idx_details (
491: terr_values_idx_details_id
492: ,terr_values_idx_header_id
493: ,last_update_date
494: ,last_updated_by

Line 502: jty_terr_values_idx_details_s.nextval

498: ,values_col_map
499: ,input_selectivity
500: ,input_ordinal_selectivity )
501: VALUES (
502: jty_terr_values_idx_details_s.nextval
503: ,l_header_seq
504: ,G_SYSDATE
505: ,G_USER_ID
506: ,G_SYSDATE

Line 515: INSERT INTO jty_terr_values_idx_details (

511: ,null);
512: END IF;
513:
514: IF (q_detail.high_value_char IS NOT NULL) THEN
515: INSERT INTO jty_terr_values_idx_details (
516: terr_values_idx_details_id
517: ,terr_values_idx_header_id
518: ,last_update_date
519: ,last_updated_by

Line 527: jty_terr_values_idx_details_s.nextval

523: ,values_col_map
524: ,input_selectivity
525: ,input_ordinal_selectivity )
526: VALUES (
527: jty_terr_values_idx_details_s.nextval
528: ,l_header_seq
529: ,G_SYSDATE
530: ,G_USER_ID
531: ,G_SYSDATE

Line 540: INSERT INTO jty_terr_values_idx_details (

536: ,null);
537: END IF;
538:
539: IF (q_detail.low_value_number IS NOT NULL) THEN
540: INSERT INTO jty_terr_values_idx_details (
541: terr_values_idx_details_id
542: ,terr_values_idx_header_id
543: ,last_update_date
544: ,last_updated_by

Line 552: jty_terr_values_idx_details_s.nextval

548: ,values_col_map
549: ,input_selectivity
550: ,input_ordinal_selectivity )
551: VALUES (
552: jty_terr_values_idx_details_s.nextval
553: ,l_header_seq
554: ,G_SYSDATE
555: ,G_USER_ID
556: ,G_SYSDATE

Line 565: INSERT INTO jty_terr_values_idx_details (

561: ,null);
562: END IF;
563:
564: IF (q_detail.high_value_number IS NOT NULL) THEN
565: INSERT INTO jty_terr_values_idx_details (
566: terr_values_idx_details_id
567: ,terr_values_idx_header_id
568: ,last_update_date
569: ,last_updated_by

Line 577: jty_terr_values_idx_details_s.nextval

573: ,values_col_map
574: ,input_selectivity
575: ,input_ordinal_selectivity )
576: VALUES (
577: jty_terr_values_idx_details_s.nextval
578: ,l_header_seq
579: ,G_SYSDATE
580: ,G_USER_ID
581: ,G_SYSDATE

Line 590: INSERT INTO jty_terr_values_idx_details (

586: ,null);
587: END IF;
588:
589: IF (q_detail.interest_type_id IS NOT NULL) THEN
590: INSERT INTO jty_terr_values_idx_details (
591: terr_values_idx_details_id
592: ,terr_values_idx_header_id
593: ,last_update_date
594: ,last_updated_by

Line 602: jty_terr_values_idx_details_s.nextval

598: ,values_col_map
599: ,input_selectivity
600: ,input_ordinal_selectivity )
601: VALUES (
602: jty_terr_values_idx_details_s.nextval
603: ,l_header_seq
604: ,G_SYSDATE
605: ,G_USER_ID
606: ,G_SYSDATE

Line 615: INSERT INTO jty_terr_values_idx_details (

611: ,null);
612: END IF;
613:
614: IF (q_detail.primary_interest_code_id IS NOT NULL) THEN
615: INSERT INTO jty_terr_values_idx_details (
616: terr_values_idx_details_id
617: ,terr_values_idx_header_id
618: ,last_update_date
619: ,last_updated_by

Line 627: jty_terr_values_idx_details_s.nextval

623: ,values_col_map
624: ,input_selectivity
625: ,input_ordinal_selectivity )
626: VALUES (
627: jty_terr_values_idx_details_s.nextval
628: ,l_header_seq
629: ,G_SYSDATE
630: ,G_USER_ID
631: ,G_SYSDATE

Line 640: INSERT INTO jty_terr_values_idx_details (

636: ,null);
637: END IF;
638:
639: IF (q_detail.secondary_interest_code_id IS NOT NULL) THEN
640: INSERT INTO jty_terr_values_idx_details (
641: terr_values_idx_details_id
642: ,terr_values_idx_header_id
643: ,last_update_date
644: ,last_updated_by

Line 652: jty_terr_values_idx_details_s.nextval

648: ,values_col_map
649: ,input_selectivity
650: ,input_ordinal_selectivity )
651: VALUES (
652: jty_terr_values_idx_details_s.nextval
653: ,l_header_seq
654: ,G_SYSDATE
655: ,G_USER_ID
656: ,G_SYSDATE

Line 665: INSERT INTO jty_terr_values_idx_details (

661: ,null);
662: END IF;
663:
664: IF (q_detail.currency_code IS NOT NULL) THEN
665: INSERT INTO jty_terr_values_idx_details (
666: terr_values_idx_details_id
667: ,terr_values_idx_header_id
668: ,last_update_date
669: ,last_updated_by

Line 677: jty_terr_values_idx_details_s.nextval

673: ,values_col_map
674: ,input_selectivity
675: ,input_ordinal_selectivity )
676: VALUES (
677: jty_terr_values_idx_details_s.nextval
678: ,l_header_seq
679: ,G_SYSDATE
680: ,G_USER_ID
681: ,G_SYSDATE

Line 690: INSERT INTO jty_terr_values_idx_details (

686: ,null);
687: END IF;
688:
689: IF (q_detail.value1_id IS NOT NULL) THEN
690: INSERT INTO jty_terr_values_idx_details (
691: terr_values_idx_details_id
692: ,terr_values_idx_header_id
693: ,last_update_date
694: ,last_updated_by

Line 702: jty_terr_values_idx_details_s.nextval

698: ,values_col_map
699: ,input_selectivity
700: ,input_ordinal_selectivity )
701: VALUES (
702: jty_terr_values_idx_details_s.nextval
703: ,l_header_seq
704: ,G_SYSDATE
705: ,G_USER_ID
706: ,G_SYSDATE

Line 715: INSERT INTO jty_terr_values_idx_details (

711: ,null);
712: END IF;
713:
714: IF (q_detail.value2_id IS NOT NULL) THEN
715: INSERT INTO jty_terr_values_idx_details (
716: terr_values_idx_details_id
717: ,terr_values_idx_header_id
718: ,last_update_date
719: ,last_updated_by

Line 727: jty_terr_values_idx_details_s.nextval

723: ,values_col_map
724: ,input_selectivity
725: ,input_ordinal_selectivity )
726: VALUES (
727: jty_terr_values_idx_details_s.nextval
728: ,l_header_seq
729: ,G_SYSDATE
730: ,G_USER_ID
731: ,G_SYSDATE

Line 740: INSERT INTO jty_terr_values_idx_details (

736: ,null);
737: END IF;
738:
739: IF (q_detail.value3_id IS NOT NULL) THEN
740: INSERT INTO jty_terr_values_idx_details (
741: terr_values_idx_details_id
742: ,terr_values_idx_header_id
743: ,last_update_date
744: ,last_updated_by

Line 752: jty_terr_values_idx_details_s.nextval

748: ,values_col_map
749: ,input_selectivity
750: ,input_ordinal_selectivity )
751: VALUES (
752: jty_terr_values_idx_details_s.nextval
753: ,l_header_seq
754: ,G_SYSDATE
755: ,G_USER_ID
756: ,G_SYSDATE

Line 765: INSERT INTO jty_terr_values_idx_details (

761: ,null);
762: END IF;
763:
764: IF (q_detail.value4_id IS NOT NULL) THEN
765: INSERT INTO jty_terr_values_idx_details (
766: terr_values_idx_details_id
767: ,terr_values_idx_header_id
768: ,last_update_date
769: ,last_updated_by

Line 777: jty_terr_values_idx_details_s.nextval

773: ,values_col_map
774: ,input_selectivity
775: ,input_ordinal_selectivity )
776: VALUES (
777: jty_terr_values_idx_details_s.nextval
778: ,l_header_seq
779: ,G_SYSDATE
780: ,G_USER_ID
781: ,G_SYSDATE

Line 790: INSERT INTO jty_terr_values_idx_details (

786: ,null);
787: END IF;
788:
789: IF (q_detail.first_char IS NOT NULL) THEN
790: INSERT INTO jty_terr_values_idx_details (
791: terr_values_idx_details_id
792: ,terr_values_idx_header_id
793: ,last_update_date
794: ,last_updated_by

Line 802: jty_terr_values_idx_details_s.nextval

798: ,values_col_map
799: ,input_selectivity
800: ,input_ordinal_selectivity )
801: VALUES (
802: jty_terr_values_idx_details_s.nextval
803: ,l_header_seq
804: ,G_SYSDATE
805: ,G_USER_ID
806: ,G_SYSDATE

Line 1779: jty_terr_values_idx_details B

1775:
1776: CURSOR all_sets(cl_source_id number) is
1777: SELECT A.terr_values_idx_header_id, count(*) num_components
1778: FROM jty_terr_values_idx_header A,
1779: jty_terr_values_idx_details B
1780: WHERE A.source_id = cl_source_id
1781: AND A.build_index_flag = 'Y'
1782: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id
1783: AND B.values_col_map is not null

Line 1793: jty_terr_values_idx_details B

1789: , cl_terr_values_idx_header_id IN NUMBER) is
1790: SELECT * FROM (
1791: SELECT A.terr_values_idx_header_id, count(*) num_components
1792: FROM jty_terr_values_idx_header A,
1793: jty_terr_values_idx_details B
1794: WHERE A.source_id = cl_source_id
1795: AND A.terr_values_idx_header_id <> cl_terr_values_idx_header_id
1796: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id
1797: AND B.values_col_map is not null

Line 1838: FROM jty_terr_values_idx_details B

1834: FROM (
1835: SELECT rownum row_count, values_col_map, input_selectivity
1836: FROM (
1837: SELECT B.values_col_map, B.input_selectivity
1838: FROM jty_terr_values_idx_details B
1839: WHERE B.terr_values_idx_header_id = cl_set_S.terr_values_idx_header_id
1840: AND B.values_col_map IS NOT NULL
1841: ORDER BY B.input_selectivity )) S,
1842: (

Line 1846: FROM jty_terr_values_idx_details B

1842: (
1843: SELECT rownum row_count, values_col_map, input_selectivity
1844: FROM (
1845: SELECT B.values_col_map, B.input_selectivity
1846: FROM jty_terr_values_idx_details B
1847: WHERE B.terr_values_idx_header_id = cl_set_L.terr_values_idx_header_id
1848: AND B.values_col_map IS NOT NULL
1849: ORDER BY B.input_selectivity )) L
1850: WHERE S.values_col_map = L.values_col_map