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.GL_GLWACCTR_XMLP_PKG dependencies on GL_JE_SOURCES

Line 859: FROM GL_JE_SOURCES

855: C_PARAM_END_DATE := to_char(PARAM_END_DATE,C_DATE_FORMAT);
856: IF P_SOURCE IS NOT NULL THEN
857: SELECT USER_JE_SOURCE_NAME
858: INTO PARAM_SOURCE
859: FROM GL_JE_SOURCES
860: WHERE JE_SOURCE_NAME = P_SOURCE;
861: END IF;
862:
863: IF P_CATEGORY IS NOT NULL THEN

Line 966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||

962: IF ((P_STATUS = 'E') OR (P_STATUS = 'U') OR (P_BATCH_NAME IS NOT NULL)) THEN
963:
964: P_PERF_FROM :=
965: ' GL_JE_BATCHES GLB, GL_JE_HEADERS GLH '||P_LEDGER_FROM||
966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||
967: ' GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;
969:
970: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE

Line 986: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)

982: USE_NL(GLL) INDEX (GLL GL_JE_LINES_U1)
983: USE_NL(GLL)INDEX(CC GL_CODE_COMBINATIONS_U1)
984: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
985: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
986: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
987: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
988: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
989: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
990: USE_NL(FU) INDEX(FU FND_USER_U1) */';

Line 997: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)

993: USE_NL(GLL) INDEX (GLL GL_JE_LINES_U1)
994: USE_NL(GLL)INDEX(CC GL_CODE_COMBINATIONS_U1)
995: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
996: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
997: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
998: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
999: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1000: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1001: USE_NL(FU) INDEX(FU FND_USER_U1) */';

Line 1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||

1002: END IF;
1003:
1004: P_PERF_FROM :=
1005: ' GL_JE_HEADERS GLH '||P_LEDGER_FROM||
1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||
1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';
1009:
1010: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE

Line 1026: ' GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_BATCHES GLB, GL_JE_SOURCES GJS, '||

1022:
1023: P_HINT_CLAUSE := ' ';
1024: /* :P_PERF_FROM :=
1025: ' GL_JE_HEADERS GLH, GL_LEDGERS LGR,'||P_LEDGER_FROM||
1026: ' GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_BATCHES GLB, GL_JE_SOURCES GJS, '||
1027: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUNCES DOCSEQ, '||
1028: ' FND_DOCUMENT_SEQUNCES SUBDOCSEQ, FND_USER FU'; */
1029: END IF;
1030: