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

Line 82: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)

78: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
79: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
80: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
81: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
82: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
83: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
84: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
85: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
86: */ ';

Line 91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';

87: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
88: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
89: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
90: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
92: ELSE
93: P_PERIOD_INX_HINT := ' /*+ ORDERED
94: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
95: INDEX (CC GL_CODE_COMBINATIONS_N3)

Line 102: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)

98: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
99: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
100: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
101: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
102: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
103: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
104: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
105: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
106: USE_NL(LS) INDEX(LS GL_LEDGER_SET_ASSIGNMENTS_N1)

Line 112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

108: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
109: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
110: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
111: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
113: END IF;
114: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
115: P_PERIOD_INX_HINT := '/*+ ORDERED */';
116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,

Line 120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
117: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
118: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
119: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
121: END IF;
122: ELSE
123: F_PERIOD_NUM := GET_EFF_PERIOD_NUM(P_ACCESS_SET_ID
124: ,P_PERIOD_FROM);

Line 139: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)

135: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
136: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
137: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
138: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
139: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
140: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
141: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
142: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
143: */ ';

Line 148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';

144: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
145: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
146: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
147: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
149: ELSE
150: P_PERIOD_INX_HINT := ' /*+ ORDERED
151: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
152: INDEX (CC GL_CODE_COMBINATIONS_N3)

Line 159: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)

155: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
156: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
157: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
158: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
159: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
160: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
161: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
162: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
163: USE_NL(LS) INDEX(LS GL_LEDGER_SET_ASSIGNMENTS_N1)

Line 169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

165: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
166: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
167: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
168: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
170: END IF;
171: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
172: P_PERIOD_INX_HINT := '/*+ ORDERED */';
173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,

Line 177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
174: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
175: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
176: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
178: END IF;
179: END IF;
180: IF ((P_START_DATE IS NOT NULL) OR (P_END_DATE IS NOT NULL)) THEN
181: IF (P_START_DATE = P_END_DATE) THEN

Line 303: GL_JE_SOURCES

299: SELECT
300: USER_JE_SOURCE_NAME
301: INTO JRNL_SOURCE_PARAM
302: FROM
303: GL_JE_SOURCES
304: WHERE JE_SOURCE_NAME = P_SOURCE;
305: END IF;
306: IF P_CATEGORY IS NOT NULL THEN
307: SELECT