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.
[Home] [Help]
APPS.GL_AS_POST_UPG_CHK_PKG dependencies on GL_LEDGERS
Line 45: FROM GL_LEDGERS lg,
41: || '
' || NVL(lg.name, '&'||'nbsp;') || ' '
42: || '' || NVL(curr.name, '&'||'nbsp;') || ' '
43: || '' || NVL(lg.description,
44: '&'||'nbsp;') || ' ' row_text
45: FROM GL_LEDGERS lg,
46: FND_CURRENCIES_TL curr
47: WHERE lg.ledger_category_code = 'ALC'
48: AND NOT EXISTS(SELECT 'Assigned'
49: FROM GL_LEDGER_RELATIONSHIPS rs
Line 64: FROM GL_LEDGERS alc,
60: || '
' || NVL(rcurr.name, '&'||'nbsp;') || ' '
61: || '' || NVL(lkr.meaning, '&'||'nbsp;') || ' '
62: || '' || NVL(src.name, '&'||'nbsp;') || ' '
63: || '' || NVL(pcurr.name, '&'||'nbsp;') || ' ' row_text
64: FROM GL_LEDGERS alc,
65: GL_LEDGERS src,
66: FND_CURRENCIES_TL pcurr,
67: FND_CURRENCIES_TL rcurr,
68: GL_LEDGER_RELATIONSHIPS rs,
Line 65: GL_LEDGERS src,
61: || '
' || NVL(lkr.meaning, '&'||'nbsp;') || ' '
62: || '' || NVL(src.name, '&'||'nbsp;') || ' '
63: || '' || NVL(pcurr.name, '&'||'nbsp;') || ' ' row_text
64: FROM GL_LEDGERS alc,
65: GL_LEDGERS src,
66: FND_CURRENCIES_TL pcurr,
67: FND_CURRENCIES_TL rcurr,
68: GL_LEDGER_RELATIONSHIPS rs,
69: GL_LOOKUPS lkr
Line 97: FROM GL_LEDGERS src,
93: || '
' || NVL(balrs.target_ledger_name, '&'||'nbsp;') || ' '
94: || '' || NVL(tcurr.name, '&'||'nbsp;') || ' '
95: || '' || NVL(src.name, '&'||'nbsp;') || ' '
96: || '' || NVL(scurr.name, '&'||'nbsp;') || ' ' row_text
97: FROM GL_LEDGERS src,
98: GL_LEDGER_RELATIONSHIPS srcrs,
99: GL_LEDGER_RELATIONSHIPS balrs,
100: FND_CURRENCIES_TL scurr,
101: FND_CURRENCIES_TL tcurr
Line 126: GL_LEDGERS alc,
122: || '
' || NVL(alc.description, '&'||'nbsp;') || ' '
123: || '' || NVL(src.name, '&'||'nbsp;') || ' '
124: || '' || NVL(pcurr.name, '&'||'nbsp;') || ' ' row_text
125: FROM GL_LEDGER_RELATIONSHIPS rs,
126: GL_LEDGERS alc,
127: GL_LEDGERS src,
128: FND_CURRENCIES_TL pcurr,
129: FND_CURRENCIES_TL rcurr
130: WHERE rs.relationship_type_code = 'JOURNAL'
Line 127: GL_LEDGERS src,
123: || '
' || NVL(src.name, '&'||'nbsp;') || ' '
124: || '' || NVL(pcurr.name, '&'||'nbsp;') || ' ' row_text
125: FROM GL_LEDGER_RELATIONSHIPS rs,
126: GL_LEDGERS alc,
127: GL_LEDGERS src,
128: FND_CURRENCIES_TL pcurr,
129: FND_CURRENCIES_TL rcurr
130: WHERE rs.relationship_type_code = 'JOURNAL'
131: AND rs.target_ledger_category_code = 'ALC'
Line 167: FROM GL_LEDGERS src,
163: 'DD-MON-YYYY')) || ''
164: || '
' || NVL(NVL(itype.user_conversion_type,
165: rs.alc_initializing_rate_type),
166: '&'||'nbsp;') || ' ' row_text
167: FROM GL_LEDGERS src,
168: GL_LEDGER_RELATIONSHIPS rs,
169: GL_DAILY_CONVERSION_TYPES dtype,
170: GL_DAILY_CONVERSION_TYPES itype,
171: GL_LOOKUPS lkre,
Line 209: FROM GL_LEDGERS alc,
205: || '
' || NVL(appl.application_name, '&'||'nbsp;') || ' '
206: || '' || NVL(jes.user_je_source_name, '&'||'nbsp;') || ' '
207: || '' || NVL(jec.user_je_category_name,
208: '&'||'nbsp;') || ' ' row_text
209: FROM GL_LEDGERS alc,
210: GL_LEDGERS src,
211: GL_LEDGER_RELATIONSHIPS glrs,
212: GL_LEDGER_RELATIONSHIPS sublgrs,
213: GL_JE_INCLUSION_RULES jrule,
Line 210: GL_LEDGERS src,
206: || '
' || NVL(jes.user_je_source_name, '&'||'nbsp;') || ' '
207: || '' || NVL(jec.user_je_category_name,
208: '&'||'nbsp;') || ' ' row_text
209: FROM GL_LEDGERS alc,
210: GL_LEDGERS src,
211: GL_LEDGER_RELATIONSHIPS glrs,
212: GL_LEDGER_RELATIONSHIPS sublgrs,
213: GL_JE_INCLUSION_RULES jrule,
214: GL_JE_SOURCES_VL jes,
Line 262: FROM GL_LEDGERS alc,
258: '&'||'nbsp;') || ''
259: || '
' || NVL(NVL(lk2.meaning,
260: alc_inherit_conversion_type),
261: '&'||'nbsp;') || ' ' row_text
262: FROM GL_LEDGERS alc,
263: GL_LEDGERS src,
264: GL_LEDGER_RELATIONSHIPS rs,
265: FND_APPLICATION_TL appl,
266: HR_OPERATING_UNITS ou,
Line 263: GL_LEDGERS src,
259: || '
' || NVL(NVL(lk2.meaning,
260: alc_inherit_conversion_type),
261: '&'||'nbsp;') || ' ' row_text
262: FROM GL_LEDGERS alc,
263: GL_LEDGERS src,
264: GL_LEDGER_RELATIONSHIPS rs,
265: FND_APPLICATION_TL appl,
266: HR_OPERATING_UNITS ou,
267: GL_DAILY_CONVERSION_TYPES ctype,
Line 308: FROM GL_LEDGERS alc,
304: || '
' || NVL(alc.name, '&'||'nbsp;') || ' '
305: || '' || NVL(src.name, '&'||'nbsp;') || ' '
306: || '' || NVL(appl.application_name, '&'||'nbsp;') || ' '
307: || '' || NVL(ou.name, '&'||'nbsp;') || ' ' row_text
308: FROM GL_LEDGERS alc,
309: GL_LEDGERS src,
310: FND_APPLICATION_TL appl,
311: HR_OPERATING_UNITS ou,
312: (SELECT DISTINCT source_ledger_id, target_ledger_id, primary_ledger_id
Line 309: GL_LEDGERS src,
305: || '
' || NVL(src.name, '&'||'nbsp;') || ' '
306: || '' || NVL(appl.application_name, '&'||'nbsp;') || ' '
307: || '' || NVL(ou.name, '&'||'nbsp;') || ' ' row_text
308: FROM GL_LEDGERS alc,
309: GL_LEDGERS src,
310: FND_APPLICATION_TL appl,
311: HR_OPERATING_UNITS ou,
312: (SELECT DISTINCT source_ledger_id, target_ledger_id, primary_ledger_id
313: FROM GL_LEDGER_RELATIONSHIPS