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 FND_CURRENCIES_TL
Line 46: FND_CURRENCIES_TL curr
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
50: WHERE rs.target_ledger_id = lg.ledger_id
Line 66: FND_CURRENCIES_TL pcurr,
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
70: WHERE src.ledger_id = rs.source_ledger_id
Line 67: FND_CURRENCIES_TL rcurr,
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
70: WHERE src.ledger_id = rs.source_ledger_id
71: AND alc.ledger_id = rs.target_ledger_id
Line 100: FND_CURRENCIES_TL scurr,
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'
104: AND balrs.relationship_enabled_flag = 'Y'
Line 101: FND_CURRENCIES_TL tcurr
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'
104: AND balrs.relationship_enabled_flag = 'Y'
105: AND src.ledger_id = balrs.source_ledger_id
Line 128: FND_CURRENCIES_TL pcurr,
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'
132: AND alc.ledger_id = rs.target_ledger_id
Line 129: FND_CURRENCIES_TL rcurr
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'
132: AND alc.ledger_id = rs.target_ledger_id
133: AND src.ledger_id = rs.source_ledger_id