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_SQL_LIB_PVT dependencies on JTF_TAE_GEN_PVT

Line 763: JTF_TAE_GEN_PVT.write_buffer_content(

759: G_INDENT || ' , ILV.org_id' || g_newline;
760: END IF; -- p_new_mode_fetch = 'Y'
761:
762: --ARPATEL 10/14 bug#3207518
763: JTF_TAE_GEN_PVT.write_buffer_content(
764: l_qual_rules => lx_4841_sql
765: );
766:
767: lx_4841_sql := --lx_4841_sql ||

Line 1099: JTF_TAE_GEN_PVT.write_buffer_content(

1095: G_INDENT || ' , ILV.org_id' || g_newline;
1096: END IF; -- p_new_mode_fetch = 'Y'
1097:
1098: --ARPATEL 10/14 bug#3207518
1099: JTF_TAE_GEN_PVT.write_buffer_content(
1100: l_qual_rules => lx_4841_sql
1101: );
1102:
1103: lx_4841_sql := --lx_4841_sql ||

Line 1473: JTF_TAE_GEN_PVT.write_buffer_content(

1469: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
1470: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
1471:
1472: --ARPATEL 10/14 bug#3194930
1473: JTF_TAE_GEN_PVT.write_buffer_content(
1474: l_qual_rules => G_INDENT || add_SELECT_clause(p_new_mode_fetch) || g_newline
1475: );
1476:
1477: lx_324347_sql := lx_324347_sql ||

Line 1615: JTF_TAE_GEN_PVT.write_buffer_content(

1611: G_INDENT5 || 'UNION ALL ' || g_newline --||
1612: ;
1613:
1614: --ARPATEL 10/14 bug#3194930
1615: JTF_TAE_GEN_PVT.write_buffer_content(
1616: l_qual_rules => lx_324347_sql
1617: );
1618:
1619: /************************/

Line 2231: JTF_TAE_GEN_PVT.write_buffer_content(

2227: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
2228: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
2229:
2230: --ARPATEL 10/14 bug#3207518
2231: JTF_TAE_GEN_PVT.write_buffer_content(
2232: l_qual_rules => l_select_ilv2
2233: );
2234:
2235: --bug#3373462 ARPATEL: 01/30/2004

Line 2236: JTF_TAE_GEN_PVT.write_buffer_content(

2232: l_qual_rules => l_select_ilv2
2233: );
2234:
2235: --bug#3373462 ARPATEL: 01/30/2004
2236: JTF_TAE_GEN_PVT.write_buffer_content(
2237: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
2238: );
2239:
2240: lx_934313_sql :=

Line 2312: JTF_TAE_GEN_PVT.write_buffer_content(

2308: lx_934313_sql := lx_934313_sql ||
2309: G_INDENT5 || ' */ ' || g_newline ; --||
2310:
2311: /* Add SELECT columns */
2312: JTF_TAE_GEN_PVT.write_buffer_content(
2313: l_qual_rules => lx_934313_sql
2314: );
2315: --lp_SELECT_cols || g_newline ; ||
2316:

Line 2317: JTF_TAE_GEN_PVT.write_buffer_content(

2313: l_qual_rules => lx_934313_sql
2314: );
2315: --lp_SELECT_cols || g_newline ; ||
2316:
2317: JTF_TAE_GEN_PVT.write_buffer_content(
2318: l_qual_rules => lp_SELECT_cols || g_newline
2319: );
2320:
2321: lx_934313_sql_2 :=

Line 2641: JTF_TAE_GEN_PVT.write_buffer_content(

2637: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
2638: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
2639:
2640: --ARPATEL 10/14 bug#3207518
2641: JTF_TAE_GEN_PVT.write_buffer_content(
2642: l_qual_rules => l_select_ilv2
2643: );
2644:
2645: --bug#3373462 ARPATEL: 01/30/2004

Line 2646: JTF_TAE_GEN_PVT.write_buffer_content(

2642: l_qual_rules => l_select_ilv2
2643: );
2644:
2645: --bug#3373462 ARPATEL: 01/30/2004
2646: JTF_TAE_GEN_PVT.write_buffer_content(
2647: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
2648: );
2649:
2650: lx_62598971_sql :=

Line 2744: JTF_TAE_GEN_PVT.write_buffer_content(

2740: G_INDENT5 || ' */ ' || g_newline ; --||
2741: END IF;
2742:
2743: /* Add SELECT columns */
2744: JTF_TAE_GEN_PVT.write_buffer_content(
2745: l_qual_rules => lx_62598971_sql
2746: );
2747: --lp_SELECT_cols || g_newline ; ||
2748:

Line 2749: JTF_TAE_GEN_PVT.write_buffer_content(

2745: l_qual_rules => lx_62598971_sql
2746: );
2747: --lp_SELECT_cols || g_newline ; ||
2748:
2749: JTF_TAE_GEN_PVT.write_buffer_content(
2750: l_qual_rules => lp_SELECT_cols || g_newline
2751: );
2752:
2753: lx_62598971_sql_2 :=

Line 2793: JTF_TAE_GEN_PVT.write_buffer_content(

2789:
2790: G_INDENT5 || 'UNION ALL ' || g_newline ; --||
2791:
2792: --ARPATEL 10/14 bug#3207518
2793: JTF_TAE_GEN_PVT.write_buffer_content(
2794: l_qual_rules => lx_62598971_sql_2
2795: );
2796:
2797: --bug#3373462 ARPATEL: 01/30/2004

Line 2798: JTF_TAE_GEN_PVT.write_buffer_content(

2794: l_qual_rules => lx_62598971_sql_2
2795: );
2796:
2797: --bug#3373462 ARPATEL: 01/30/2004
2798: JTF_TAE_GEN_PVT.write_buffer_content(
2799: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
2800: );
2801:
2802: lx_62598971_sql_3 :=

Line 2894: JTF_TAE_GEN_PVT.write_buffer_content(

2890: G_INDENT5 || ' NO_MERGE ' || g_newline ||
2891: G_INDENT5 || ' */ ' || g_newline ; -- ||
2892: END IF;
2893:
2894: JTF_TAE_GEN_PVT.write_buffer_content(
2895: l_qual_rules => lx_62598971_sql_3
2896: );
2897:
2898: /* Add SELECT columns */

Line 2899: JTF_TAE_GEN_PVT.write_buffer_content(

2895: l_qual_rules => lx_62598971_sql_3
2896: );
2897:
2898: /* Add SELECT columns */
2899: JTF_TAE_GEN_PVT.write_buffer_content(
2900: l_qual_rules => lp_SELECT_cols || g_newline
2901: );
2902: --lp_SELECT_cols || g_newline ||
2903:

Line 2941: JTF_TAE_GEN_PVT.write_buffer_content(

2937:
2938: G_INDENT5 || 'UNION ALL ' || g_newline;
2939:
2940: --ARPATEL 10/14 bug#3207518
2941: JTF_TAE_GEN_PVT.write_buffer_content(
2942: l_qual_rules => lx_62598971_sql_4
2943: );
2944:
2945: --bug#3373462 ARPATEL: 01/30/2004

Line 2946: JTF_TAE_GEN_PVT.write_buffer_content(

2942: l_qual_rules => lx_62598971_sql_4
2943: );
2944:
2945: --bug#3373462 ARPATEL: 01/30/2004
2946: JTF_TAE_GEN_PVT.write_buffer_content(
2947: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
2948: );
2949:
2950: --G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' || g_newline ||

Line 3136: JTF_TAE_GEN_PVT.write_buffer_content(

3132:
3133: G_INDENT5 || 'UNION ALL ' || g_newline ;--||
3134:
3135: --ARPATEL 10/14 bug#3207518
3136: JTF_TAE_GEN_PVT.write_buffer_content(
3137: l_qual_rules => lx_62598971_sql_5
3138: );
3139:
3140: --bug#3373462 ARPATEL: 01/30/2004

Line 3141: JTF_TAE_GEN_PVT.write_buffer_content(

3137: l_qual_rules => lx_62598971_sql_5
3138: );
3139:
3140: --bug#3373462 ARPATEL: 01/30/2004
3141: JTF_TAE_GEN_PVT.write_buffer_content(
3142: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
3143: );
3144:
3145: lx_62598971_sql_6 :=

Line 3564: JTF_TAE_GEN_PVT.write_buffer_content(

3560: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
3561: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
3562:
3563: --ARPATEL 10/14 bug#3207518
3564: JTF_TAE_GEN_PVT.write_buffer_content(
3565: l_qual_rules => l_select_ilv2
3566: );
3567:
3568: --bug#3373462 ARPATEL: 01/30/2004

Line 3569: JTF_TAE_GEN_PVT.write_buffer_content(

3565: l_qual_rules => l_select_ilv2
3566: );
3567:
3568: --bug#3373462 ARPATEL: 01/30/2004
3569: JTF_TAE_GEN_PVT.write_buffer_content(
3570: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
3571: );
3572:
3573: lx_45084233_sql :=

Line 3657: JTF_TAE_GEN_PVT.write_buffer_content(

3653: G_INDENT5 || ' INDEX(Q1012R1 JTF_TERR_QUAL_RULES_MV_N10) ' || g_newline ||
3654: G_INDENT5 || ' */ ' || g_newline ; --||
3655:
3656: /* Add SELECT columns */
3657: JTF_TAE_GEN_PVT.write_buffer_content(
3658: l_qual_rules => lx_45084233_sql
3659: );
3660: --lp_SELECT_cols || g_newline ; ||
3661:

Line 3662: JTF_TAE_GEN_PVT.write_buffer_content(

3658: l_qual_rules => lx_45084233_sql
3659: );
3660: --lp_SELECT_cols || g_newline ; ||
3661:
3662: JTF_TAE_GEN_PVT.write_buffer_content(
3663: l_qual_rules => lp_SELECT_cols || g_newline
3664: );
3665:
3666: lx_45084233_sql_2 :=

Line 3698: JTF_TAE_GEN_PVT.write_buffer_content(

3694:
3695: G_INDENT5 || 'UNION ALL ' || g_newline ; --||
3696:
3697: --ARPATEL 10/14 bug#3207518
3698: JTF_TAE_GEN_PVT.write_buffer_content(
3699: l_qual_rules => lx_45084233_sql_2
3700: );
3701:
3702: --bug#3373462 ARPATEL: 01/30/2004

Line 3703: JTF_TAE_GEN_PVT.write_buffer_content(

3699: l_qual_rules => lx_45084233_sql_2
3700: );
3701:
3702: --bug#3373462 ARPATEL: 01/30/2004
3703: JTF_TAE_GEN_PVT.write_buffer_content(
3704: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
3705: );
3706:
3707: lx_45084233_sql_3 :=

Line 3791: JTF_TAE_GEN_PVT.write_buffer_content(

3787: G_INDENT5 || ' INDEX(Q1007R1 JTF_TERR_QUAL_RULES_MV_N10) ' || g_newline ||
3788: G_INDENT5 || ' INDEX(Q1012LK JTF_TERR_CNR_QUAL_LIKE_MV_N10) ' || g_newline ||
3789: G_INDENT5 || ' */ ' || g_newline ; -- ||
3790:
3791: JTF_TAE_GEN_PVT.write_buffer_content(
3792: l_qual_rules => lx_45084233_sql_3
3793: );
3794:
3795: /* Add SELECT columns */

Line 3796: JTF_TAE_GEN_PVT.write_buffer_content(

3792: l_qual_rules => lx_45084233_sql_3
3793: );
3794:
3795: /* Add SELECT columns */
3796: JTF_TAE_GEN_PVT.write_buffer_content(
3797: l_qual_rules => lp_SELECT_cols || g_newline
3798: );
3799: --lp_SELECT_cols || g_newline ||
3800:

Line 3830: JTF_TAE_GEN_PVT.write_buffer_content(

3826:
3827: G_INDENT5 || 'UNION ALL ' || g_newline;
3828:
3829: --ARPATEL 10/14 bug#3207518
3830: JTF_TAE_GEN_PVT.write_buffer_content(
3831: l_qual_rules => lx_45084233_sql_4
3832: );
3833:
3834: --bug#3373462 ARPATEL: 01/30/2004

Line 3835: JTF_TAE_GEN_PVT.write_buffer_content(

3831: l_qual_rules => lx_45084233_sql_4
3832: );
3833:
3834: --bug#3373462 ARPATEL: 01/30/2004
3835: JTF_TAE_GEN_PVT.write_buffer_content(
3836: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
3837: );
3838:
3839: --G_INDENT || 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) ' || g_newline ||

Line 3991: JTF_TAE_GEN_PVT.write_buffer_content(

3987:
3988: G_INDENT5 || 'UNION ALL ' || g_newline ;--||
3989:
3990: --ARPATEL 10/14 bug#3207518
3991: JTF_TAE_GEN_PVT.write_buffer_content(
3992: l_qual_rules => lx_45084233_sql_5
3993: );
3994:
3995: --bug#3373462 ARPATEL: 01/30/2004

Line 3996: JTF_TAE_GEN_PVT.write_buffer_content(

3992: l_qual_rules => lx_45084233_sql_5
3993: );
3994:
3995: --bug#3373462 ARPATEL: 01/30/2004
3996: JTF_TAE_GEN_PVT.write_buffer_content(
3997: G_INDENT || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
3998: );
3999:
4000: lx_45084233_sql_6 :=

Line 4364: JTF_TAE_GEN_PVT.write_buffer_content(

4360: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
4361: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
4362:
4363: --ARPATEL 10/14 bug#3207518
4364: JTF_TAE_GEN_PVT.write_buffer_content(
4365: l_qual_rules => l_select_ilv2
4366: );
4367:
4368: --bug#3373462 ARPATEL: 01/30/2004

Line 4371: JTF_TAE_GEN_PVT.write_buffer_content(

4367:
4368: --bug#3373462 ARPATEL: 01/30/2004
4369: IF p_new_mode_fetch = 'Y'
4370: THEN
4371: JTF_TAE_GEN_PVT.write_buffer_content(
4372: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
4373: );
4374: ELSE
4375: JTF_TAE_GEN_PVT.write_buffer_content(

Line 4375: JTF_TAE_GEN_PVT.write_buffer_content(

4371: JTF_TAE_GEN_PVT.write_buffer_content(
4372: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
4373: );
4374: ELSE
4375: JTF_TAE_GEN_PVT.write_buffer_content(
4376: G_INDENT5 || 'FROM ' || g_newline
4377: );
4378: END IF;
4379:

Line 4411: JTF_TAE_GEN_PVT.write_buffer_content(

4407: END IF;
4408:
4409:
4410: --ARPATEL 10/14 bug#3207518
4411: JTF_TAE_GEN_PVT.write_buffer_content(
4412: l_qual_rules => lx_924631_sql_1
4413: );
4414:
4415: /* Add SELECT columns */

Line 4417: JTF_TAE_GEN_PVT.write_buffer_content(

4413: );
4414:
4415: /* Add SELECT columns */
4416: --ARPATEL 10/14 bug#3207518
4417: JTF_TAE_GEN_PVT.write_buffer_content(
4418: l_qual_rules => lp_SELECT_cols || g_newline
4419: );
4420: --lp_SELECT_cols || g_newline
4421:

Line 4792: JTF_TAE_GEN_PVT.write_buffer_content(

4788: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
4789: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
4790:
4791: --ARPATEL 10/14 bug#3207518
4792: JTF_TAE_GEN_PVT.write_buffer_content(
4793: l_qual_rules => l_select_ilv2
4794: );
4795:
4796: --bug#3373462 ARPATEL: 01/30/2004

Line 4799: JTF_TAE_GEN_PVT.write_buffer_content(

4795:
4796: --bug#3373462 ARPATEL: 01/30/2004
4797: IF p_new_mode_fetch = 'Y'
4798: THEN
4799: JTF_TAE_GEN_PVT.write_buffer_content(
4800: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
4801: );
4802: ELSE
4803: JTF_TAE_GEN_PVT.write_buffer_content(

Line 4803: JTF_TAE_GEN_PVT.write_buffer_content(

4799: JTF_TAE_GEN_PVT.write_buffer_content(
4800: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
4801: );
4802: ELSE
4803: JTF_TAE_GEN_PVT.write_buffer_content(
4804: G_INDENT5 || 'FROM ' || g_newline
4805: );
4806: END IF;
4807:

Line 4841: JTF_TAE_GEN_PVT.write_buffer_content(

4837: END IF;
4838:
4839:
4840: --ARPATEL 10/14 bug#3207518
4841: JTF_TAE_GEN_PVT.write_buffer_content(
4842: l_qual_rules => lx_61950277_sql_1
4843: );
4844:
4845: /* Add SELECT columns */

Line 4847: JTF_TAE_GEN_PVT.write_buffer_content(

4843: );
4844:
4845: /* Add SELECT columns */
4846: --ARPATEL 10/14 bug#3207518
4847: JTF_TAE_GEN_PVT.write_buffer_content(
4848: l_qual_rules => lp_SELECT_cols || g_newline
4849: );
4850: --lp_SELECT_cols || g_newline
4851:

Line 4915: JTF_TAE_GEN_PVT.write_buffer_content(

4911: G_INDENT5 || ' */ ' || g_newline ; --||
4912: END IF;
4913:
4914: --ARPATEL 10/14 bug#3207518
4915: JTF_TAE_GEN_PVT.write_buffer_content(
4916: l_qual_rules => lx_61950277_sql
4917: );
4918:
4919: /* Add SELECT columns */

Line 4921: JTF_TAE_GEN_PVT.write_buffer_content(

4917: );
4918:
4919: /* Add SELECT columns */
4920: --ARPATEL 10/14 bug#3207518
4921: JTF_TAE_GEN_PVT.write_buffer_content(
4922: l_qual_rules => lp_SELECT_cols || g_newline
4923: );
4924: --lp_SELECT_cols || g_newline ||
4925:

Line 4986: JTF_TAE_GEN_PVT.write_buffer_content(

4982: END IF;
4983:
4984:
4985: --ARPATEL 10/14 bug#3207518
4986: JTF_TAE_GEN_PVT.write_buffer_content(
4987: l_qual_rules => lx_61950277_sql_2
4988: );
4989:
4990: /* Add SELECT columns */

Line 4992: JTF_TAE_GEN_PVT.write_buffer_content(

4988: );
4989:
4990: /* Add SELECT columns */
4991: --ARPATEL 10/14 bug#3207518
4992: JTF_TAE_GEN_PVT.write_buffer_content(
4993: l_qual_rules => lp_SELECT_cols || g_newline
4994: );
4995: --lp_SELECT_cols || g_newline ||
4996:

Line 5052: JTF_TAE_GEN_PVT.write_buffer_content(

5048: G_INDENT5 || ' */ ' || g_newline ; --||
5049: END IF;
5050:
5051: --ARPATEL 10/14 bug#3207518
5052: JTF_TAE_GEN_PVT.write_buffer_content(
5053: l_qual_rules => lx_61950277_sql_3
5054: );
5055:
5056: /* Add SELECT columns */

Line 5058: JTF_TAE_GEN_PVT.write_buffer_content(

5054: );
5055:
5056: /* Add SELECT columns */
5057: --ARPATEL 10/14 bug#3207518
5058: JTF_TAE_GEN_PVT.write_buffer_content(
5059: l_qual_rules => lp_SELECT_cols || g_newline
5060: );
5061: --lp_SELECT_cols || g_newline ||
5062:

Line 5122: JTF_TAE_GEN_PVT.write_buffer_content(

5118: G_INDENT5 || ' */ ' || g_newline ; --||
5119: END IF;
5120:
5121: --ARPATEL 10/14 bug#3207518
5122: JTF_TAE_GEN_PVT.write_buffer_content(
5123: l_qual_rules => lx_61950277_sql_4
5124: );
5125:
5126: /* Add SELECT columns */

Line 5128: JTF_TAE_GEN_PVT.write_buffer_content(

5124: );
5125:
5126: /* Add SELECT columns */
5127: --ARPATEL 10/14 bug#3207518
5128: JTF_TAE_GEN_PVT.write_buffer_content(
5129: l_qual_rules => lp_SELECT_cols || g_newline
5130: );
5131: /* Add SELECT columns */
5132: --lp_SELECT_cols || g_newline ||

Line 5513: JTF_TAE_GEN_PVT.write_buffer_content(

5509: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
5510: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
5511:
5512: --ARPATEL 10/14 bug#3207518
5513: JTF_TAE_GEN_PVT.write_buffer_content(
5514: l_qual_rules => l_select_ilv2
5515: );
5516:
5517: --bug#3373462 ARPATEL: 01/30/2004

Line 5520: JTF_TAE_GEN_PVT.write_buffer_content(

5516:
5517: --bug#3373462 ARPATEL: 01/30/2004
5518: IF p_new_mode_fetch = 'Y'
5519: THEN
5520: JTF_TAE_GEN_PVT.write_buffer_content(
5521: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
5522: );
5523: ELSE
5524: JTF_TAE_GEN_PVT.write_buffer_content(

Line 5524: JTF_TAE_GEN_PVT.write_buffer_content(

5520: JTF_TAE_GEN_PVT.write_buffer_content(
5521: G_INDENT5 || 'FROM ( ' || g_newline || EXP_PURCHASE_UNION_SELECT(p_new_mode_fetch)
5522: );
5523: ELSE
5524: JTF_TAE_GEN_PVT.write_buffer_content(
5525: G_INDENT5 || 'FROM ' || g_newline
5526: );
5527: END IF;
5528:

Line 5551: JTF_TAE_GEN_PVT.write_buffer_content(

5547: G_INDENT5 || ' */ ' || g_newline ; --||
5548:
5549:
5550: --ARPATEL 10/14 bug#3207518
5551: JTF_TAE_GEN_PVT.write_buffer_content(
5552: l_qual_rules => lx_44435539_sql_1
5553: );
5554:
5555: /* Add SELECT columns */

Line 5557: JTF_TAE_GEN_PVT.write_buffer_content(

5553: );
5554:
5555: /* Add SELECT columns */
5556: --ARPATEL 10/14 bug#3207518
5557: JTF_TAE_GEN_PVT.write_buffer_content(
5558: l_qual_rules => lp_SELECT_cols || g_newline
5559: );
5560: --lp_SELECT_cols || g_newline
5561:

Line 5608: JTF_TAE_GEN_PVT.write_buffer_content(

5604: G_INDENT5 || ' INDEX(Q1012LK JTF_TERR_CNR_QUAL_LIKE_MV_N10) ' || g_newline ||
5605: G_INDENT5 || ' */ ' || g_newline ; --||
5606:
5607: --ARPATEL 10/14 bug#3207518
5608: JTF_TAE_GEN_PVT.write_buffer_content(
5609: l_qual_rules => lx_44435539_sql
5610: );
5611:
5612: /* Add SELECT columns */

Line 5614: JTF_TAE_GEN_PVT.write_buffer_content(

5610: );
5611:
5612: /* Add SELECT columns */
5613: --ARPATEL 10/14 bug#3207518
5614: JTF_TAE_GEN_PVT.write_buffer_content(
5615: l_qual_rules => lp_SELECT_cols || g_newline
5616: );
5617: --lp_SELECT_cols || g_newline ||
5618:

Line 5663: JTF_TAE_GEN_PVT.write_buffer_content(

5659: G_INDENT5 || ' */ ' || g_newline ; --||
5660:
5661:
5662: --ARPATEL 10/14 bug#3207518
5663: JTF_TAE_GEN_PVT.write_buffer_content(
5664: l_qual_rules => lx_44435539_sql_2
5665: );
5666:
5667: /* Add SELECT columns */

Line 5669: JTF_TAE_GEN_PVT.write_buffer_content(

5665: );
5666:
5667: /* Add SELECT columns */
5668: --ARPATEL 10/14 bug#3207518
5669: JTF_TAE_GEN_PVT.write_buffer_content(
5670: l_qual_rules => lp_SELECT_cols || g_newline
5671: );
5672: --lp_SELECT_cols || g_newline ||
5673:

Line 5713: JTF_TAE_GEN_PVT.write_buffer_content(

5709: G_INDENT5 || ' INDEX(Q1012LK JTF_TERR_CNR_QUAL_LIKE_MV_N10) ' || g_newline ||
5710: G_INDENT5 || ' */ ' || g_newline ; --||
5711:
5712: --ARPATEL 10/14 bug#3207518
5713: JTF_TAE_GEN_PVT.write_buffer_content(
5714: l_qual_rules => lx_44435539_sql_3
5715: );
5716:
5717: /* Add SELECT columns */

Line 5719: JTF_TAE_GEN_PVT.write_buffer_content(

5715: );
5716:
5717: /* Add SELECT columns */
5718: --ARPATEL 10/14 bug#3207518
5719: JTF_TAE_GEN_PVT.write_buffer_content(
5720: l_qual_rules => lp_SELECT_cols || g_newline
5721: );
5722: --lp_SELECT_cols || g_newline ||
5723:

Line 5765: JTF_TAE_GEN_PVT.write_buffer_content(

5761: G_INDENT5 || ' INDEX(Q1012BT JTF_TERR_CNR_QUAL_BTWN_MV_N10) ' || g_newline ||
5762: G_INDENT5 || ' */ ' || g_newline ; --||
5763:
5764: --ARPATEL 10/14 bug#3207518
5765: JTF_TAE_GEN_PVT.write_buffer_content(
5766: l_qual_rules => lx_44435539_sql_4
5767: );
5768:
5769: /* Add SELECT columns */

Line 5771: JTF_TAE_GEN_PVT.write_buffer_content(

5767: );
5768:
5769: /* Add SELECT columns */
5770: --ARPATEL 10/14 bug#3207518
5771: JTF_TAE_GEN_PVT.write_buffer_content(
5772: l_qual_rules => lp_SELECT_cols || g_newline
5773: );
5774: /* Add SELECT columns */
5775: --lp_SELECT_cols || g_newline ||

Line 6231: JTF_TAE_GEN_PVT.write_buffer_content(

6227: G_INDENT5 || 'ILV.top_level_terr_id, ILV.num_winners, ILV.org_id ';
6228: END IF;
6229:
6230:
6231: JTF_TAE_GEN_PVT.write_buffer_content(
6232: l_qual_rules => l_select_ilv2 || ' FROM ' ||g_newline ||
6233: G_INDENT5 || '( SELECT /*+ NO_MERGE USE_CONCAT */ ' || g_newline
6234: );
6235:

Line 6244: JTF_TAE_GEN_PVT.write_buffer_content(

6240:
6241: /* STATIC INLINE VIEW */
6242: add_ILV_with_NOMERGE_hint(l_sql, p_new_mode_fetch);
6243:
6244: JTF_TAE_GEN_PVT.write_buffer_content(
6245: l_qual_rules => lx_663217_sql
6246: );
6247:
6248: lx_663217_sql_1 :=

Line 6286: JTF_TAE_GEN_PVT.write_buffer_content(

6282: G_INDENT5 || ' , ILV.num_winners' || g_newline ||
6283: G_INDENT5 || ' , ILV.org_id' || g_newline ||
6284: G_INDENT5 || ' FROM jtf_terr_qual_rules_mv Q1018R1, ' || g_newline;
6285:
6286: JTF_TAE_GEN_PVT.write_buffer_content(
6287: l_qual_rules => lx_663217_sql_1
6288: );
6289:
6290: /* STATIC INLINE VIEW */

Line 6291: JTF_TAE_GEN_PVT.write_buffer_content(

6287: l_qual_rules => lx_663217_sql_1
6288: );
6289:
6290: /* STATIC INLINE VIEW */
6291: JTF_TAE_GEN_PVT.write_buffer_content(
6292: add_ILV_with_NOMERGE_hint(l_sql, p_new_mode_fetch)
6293: );
6294:
6295: lx_663217_sql_2 :=

Line 6569: JTF_TAE_GEN_PVT.write_buffer_content(

6565: G_INDENT5 || ' AND Q1003R1.qual_usg_id = -1003 ' || g_newline ||
6566: G_INDENT5 || ' AND Q1003R1.terr_id = ILV.terr_id ' || g_newline ;
6567:
6568: --ARPATEL 10/14 bug#3194930
6569: JTF_TAE_GEN_PVT.write_buffer_content(
6570: l_qual_rules => G_INDENT || add_SELECT_clause(p_new_mode_fetch) || g_newline
6571: );
6572:
6573: lx_353393_sql := lx_353393_sql ||

Line 6711: JTF_TAE_GEN_PVT.write_buffer_content(

6707: G_INDENT5 || 'UNION ALL ' || g_newline --||
6708: ;
6709:
6710: --ARPATEL 10/14 bug#3194930
6711: JTF_TAE_GEN_PVT.write_buffer_content(
6712: l_qual_rules => lx_353393_sql
6713: );
6714:
6715: /************************/

Line 6777: JTF_TAE_GEN_PVT.write_buffer_content(

6773: G_INDENT5 || ' Q1102LK.first_char = ''%'' ' || g_newline ||
6774: G_INDENT5 || ' AND Q1102LK.qual_usg_id = -1102 ' || g_newline ||
6775: G_INDENT5 || ' AND Q1102LK.terr_id = ILV.terr_id ' || g_newline;
6776:
6777: JTF_TAE_GEN_PVT.write_buffer_content(
6778: l_qual_rules => lx_353393_sql_1
6779: );
6780:
6781: lx_353393_sql_2 :=

Line 6840: JTF_TAE_GEN_PVT.write_buffer_content(

6836: G_INDENT5 || ' Q1102LK.first_char = ''%'' ' || g_newline ||
6837: G_INDENT5 || ' AND Q1102LK.qual_usg_id = -1102 ' || g_newline ||
6838: G_INDENT5 || ' AND Q1102LK.terr_id = ILV.terr_id ' || g_newline;
6839:
6840: JTF_TAE_GEN_PVT.write_buffer_content(
6841: l_qual_rules => lx_353393_sql_2
6842: );
6843:
6844: lx_353393_sql_3 :=