[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ''
|| '' || NVL(lg.name, '&'||'nbsp;') || ' '
Line: 48
AND NOT EXISTS(SELECT 'Assigned'
FROM GL_LEDGER_RELATIONSHIPS rs
WHERE rs.target_ledger_id = lg.ledger_id
AND rs.target_ledger_category_code = 'ALC'
AND rs.relationship_type_code IN ('JOURNAL', 'SUBLEDGER'))
AND curr.currency_code = lg.currency_code
AND curr.language = USERENV('LANG')
ORDER BY lg.name;
Line: 58
SELECT distinct ''
|| '' || NVL(alc.name, '&'||'nbsp;') || ' '
Line: 82
(SELECT rs2.target_ledger_id
FROM GL_LEDGER_RELATIONSHIPS rs2
WHERE rs2.relationship_enabled_flag = 'Y'
AND rs2.target_ledger_category_code = 'ALC'
AND rs2.relationship_type_code IN ('JOURNAL', 'SUBLEDGER')
HAVING COUNT(distinct rs2.source_ledger_id) > 1
GROUP BY rs2.target_ledger_id)
ORDER BY row_text;
Line: 92
SELECT ''
|| '' || NVL(balrs.target_ledger_name, '&'||'nbsp;') || ' '
Line: 119
SELECT ''
|| '' || NVL(alc.name, '&'||'nbsp;') || ' '
Line: 138
AND EXISTS (SELECT 'Upgraded from MRC RSOB'
FROM GL_MC_BOOK_ASSIGNMENTS_11i
WHERE primary_set_of_books_id = rs.source_ledger_id
AND reporting_set_of_books_id = rs.target_ledger_id)
ORDER BY alc.name, src.name;
Line: 145
SELECT ''
|| '' || NVL(rs.target_ledger_name, '&'||'nbsp;') || ' '
Line: 194
AND NOT EXISTS (SELECT 'Exists in GL_MC_REPORTING_OPTIONS'
FROM GL_MC_REPORTING_OPTIONS_11i
WHERE primary_set_of_books_id = rs.source_ledger_id
AND reporting_set_of_books_id = rs.target_ledger_id
AND application_id = 101)
ORDER BY rs.target_ledger_name, src.name;
Line: 202
SELECT ''
|| '' || NVL(alc.name, '&'||'nbsp;') || ' '
Line: 248
SELECT ''
|| '' || NVL(alc.name, '&'||'nbsp;') || ' '
Line: 286
SELECT 'Different setup'
FROM GL_LEDGER_RELATIONSHIPS rs2
WHERE rs2.target_ledger_id = rs.target_ledger_id
AND rs2.source_ledger_id = rs.source_ledger_id
AND rs2.primary_ledger_id = rs.primary_ledger_id
AND rs2.target_ledger_category_code = 'ALC'
AND rs2.relationship_type_code = 'SUBLEDGER'
AND rs2.relationship_id <> rs.relationship_id
AND ( rs2.alc_default_conv_rate_type
<> rs.alc_default_conv_rate_type
OR rs2.alc_no_rate_action_code
<> rs.alc_no_rate_action_code
OR rs2.alc_inherit_conversion_type
<> rs.alc_inherit_conversion_type))
ORDER BY alc.name, src.name, appl.application_name, ou.name;
Line: 303
SELECT ''
|| '' || NVL(alc.name, '&'||'nbsp;') || ' '
Line: 312
(SELECT DISTINCT source_ledger_id, target_ledger_id, primary_ledger_id
FROM GL_LEDGER_RELATIONSHIPS
WHERE target_ledger_category_code = 'ALC'
AND relationship_type_code = 'SUBLEDGER'
AND application_id <> 101
AND relationship_enabled_flag = 'Y') qrs
WHERE alc.ledger_id = qrs.target_ledger_id
AND src.ledger_id = qrs.source_ledger_id
AND ou.set_of_books_id (+) = qrs.primary_ledger_id
AND appl.application_id IN (101, 140, 200, 201, 222, 275)
AND appl.language = USERENV('LANG')
AND NOT EXISTS
(SELECT 'Enabled relatinoship defined'
FROM GL_LEDGER_RELATIONSHIPS rs
WHERE rs.target_ledger_category_code = 'ALC'
AND rs.relationship_type_code = 'SUBLEDGER'
AND rs.relationship_enabled_flag = 'Y'
AND rs.application_id = appl.application_id
AND rs.target_ledger_id = alc.ledger_id
AND rs.source_ledger_id = src.ledger_id
AND ( NVL(rs.org_id, -99) = -99
OR rs.org_id = ou.organization_id))
ORDER BY alc.name, src.name, appl.application_name, ou.name;