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_AS_POST_UPG_CHK_PKG dependencies on GL_LOOKUPS

Line 69: GL_LOOKUPS lkr

65: GL_LEDGERS src,
66: FND_CURRENCIES_TL pcurr,
67: FND_CURRENCIES_TL rcurr,
68: GL_LEDGER_RELATIONSHIPS rs,
69: GL_LOOKUPS lkr
70: WHERE src.ledger_id = rs.source_ledger_id
71: AND alc.ledger_id = rs.target_ledger_id
72: AND rcurr.currency_code = alc.currency_code
73: AND rcurr.language = USERENV('LANG')

Line 171: GL_LOOKUPS lkre,

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,
172: GL_LOOKUPS lknra,
173: GL_LOOKUPS lkict,
174: GL_LOOKUPS lkico
175: WHERE rs.target_ledger_category_code = 'ALC'

Line 172: GL_LOOKUPS lknra,

168: GL_LEDGER_RELATIONSHIPS rs,
169: GL_DAILY_CONVERSION_TYPES dtype,
170: GL_DAILY_CONVERSION_TYPES itype,
171: GL_LOOKUPS lkre,
172: GL_LOOKUPS lknra,
173: GL_LOOKUPS lkict,
174: GL_LOOKUPS lkico
175: WHERE rs.target_ledger_category_code = 'ALC'
176: AND rs.relationship_type_code = 'SUBLEDGER'

Line 173: GL_LOOKUPS lkict,

169: GL_DAILY_CONVERSION_TYPES dtype,
170: GL_DAILY_CONVERSION_TYPES itype,
171: GL_LOOKUPS lkre,
172: GL_LOOKUPS lknra,
173: GL_LOOKUPS lkict,
174: GL_LOOKUPS lkico
175: WHERE rs.target_ledger_category_code = 'ALC'
176: AND rs.relationship_type_code = 'SUBLEDGER'
177: AND rs.application_id = 101

Line 174: GL_LOOKUPS lkico

170: GL_DAILY_CONVERSION_TYPES itype,
171: GL_LOOKUPS lkre,
172: GL_LOOKUPS lknra,
173: GL_LOOKUPS lkict,
174: GL_LOOKUPS lkico
175: WHERE rs.target_ledger_category_code = 'ALC'
176: AND rs.relationship_type_code = 'SUBLEDGER'
177: AND rs.application_id = 101
178: AND rs.created_by = 1

Line 268: GL_LOOKUPS lk1,

264: GL_LEDGER_RELATIONSHIPS rs,
265: FND_APPLICATION_TL appl,
266: HR_OPERATING_UNITS ou,
267: GL_DAILY_CONVERSION_TYPES ctype,
268: GL_LOOKUPS lk1,
269: GL_LOOKUPS lk2
270: WHERE alc.ledger_id = rs.target_ledger_id
271: AND src.ledger_id = rs.source_ledger_id
272: AND appl.application_id = rs.application_id

Line 269: GL_LOOKUPS lk2

265: FND_APPLICATION_TL appl,
266: HR_OPERATING_UNITS ou,
267: GL_DAILY_CONVERSION_TYPES ctype,
268: GL_LOOKUPS lk1,
269: GL_LOOKUPS lk2
270: WHERE alc.ledger_id = rs.target_ledger_id
271: AND src.ledger_id = rs.source_ledger_id
272: AND appl.application_id = rs.application_id
273: AND appl.language = USERENV('LANG')