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_LEDGER_RELATIONSHIPS

Line 49: FROM GL_LEDGER_RELATIONSHIPS rs

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
50: WHERE rs.target_ledger_id = lg.ledger_id
51: AND rs.target_ledger_category_code = 'ALC'
52: AND rs.relationship_type_code IN ('JOURNAL', 'SUBLEDGER'))
53: AND curr.currency_code = lg.currency_code

Line 68: GL_LEDGER_RELATIONSHIPS rs,

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
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

Line 83: FROM GL_LEDGER_RELATIONSHIPS rs2

79: AND lkr.lookup_type = 'GL_ASF_ALC_RELATIONSHIP_LEVEL'
80: AND rs.relationship_enabled_flag = 'Y'
81: AND rs.target_ledger_id IN
82: (SELECT rs2.target_ledger_id
83: FROM GL_LEDGER_RELATIONSHIPS rs2
84: WHERE rs2.relationship_enabled_flag = 'Y'
85: AND rs2.target_ledger_category_code = 'ALC'
86: AND rs2.relationship_type_code IN ('JOURNAL', 'SUBLEDGER')
87: HAVING COUNT(distinct rs2.source_ledger_id) > 1

Line 98: GL_LEDGER_RELATIONSHIPS srcrs,

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
102: WHERE balrs.relationship_type_code = 'BALANCE'

Line 99: GL_LEDGER_RELATIONSHIPS balrs,

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
102: WHERE balrs.relationship_type_code = 'BALANCE'
103: AND balrs.target_ledger_category_code = 'ALC'

Line 125: FROM GL_LEDGER_RELATIONSHIPS rs,

121: || '' || NVL(rcurr.name, '&'||'nbsp;') || ''
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

Line 168: GL_LEDGER_RELATIONSHIPS rs,

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,
172: GL_LOOKUPS lknra,

Line 211: GL_LEDGER_RELATIONSHIPS glrs,

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,
215: GL_JE_CATEGORIES_VL jec,

Line 212: GL_LEDGER_RELATIONSHIPS sublgrs,

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,
215: GL_JE_CATEGORIES_VL jec,
216: FND_APPLICATION_TL appl

Line 264: GL_LEDGER_RELATIONSHIPS rs,

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,
268: GL_LOOKUPS lk1,

Line 287: FROM GL_LEDGER_RELATIONSHIPS rs2

283: AND lk2.lookup_type (+) = 'YES/NO'
284: AND lk2.enabled_flag (+) = 'Y'
285: AND EXISTS (
286: SELECT 'Different setup'
287: FROM GL_LEDGER_RELATIONSHIPS rs2
288: WHERE rs2.target_ledger_id = rs.target_ledger_id
289: AND rs2.source_ledger_id = rs.source_ledger_id
290: AND rs2.primary_ledger_id = rs.primary_ledger_id
291: AND rs2.target_ledger_category_code = 'ALC'

Line 313: FROM GL_LEDGER_RELATIONSHIPS

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
314: WHERE target_ledger_category_code = 'ALC'
315: AND relationship_type_code = 'SUBLEDGER'
316: AND application_id <> 101
317: AND relationship_enabled_flag = 'Y') qrs

Line 325: FROM GL_LEDGER_RELATIONSHIPS rs

321: AND appl.application_id IN (101, 140, 200, 201, 222, 275)
322: AND appl.language = USERENV('LANG')
323: AND NOT EXISTS
324: (SELECT 'Enabled relatinoship defined'
325: FROM GL_LEDGER_RELATIONSHIPS rs
326: WHERE rs.target_ledger_category_code = 'ALC'
327: AND rs.relationship_type_code = 'SUBLEDGER'
328: AND rs.relationship_enabled_flag = 'Y'
329: AND rs.application_id = appl.application_id