[Home] [Help]
181: -- ledgers (which is generally not the case), we will return the first row
182: -- found.
183: SELECT source_ledger_id
184: INTO l_src_ledger_id
185: FROM GL_LEDGER_RELATIONSHIPS GLR
186: WHERE GLR.target_ledger_id = n_ledger_id
187: AND GLR.target_ledger_category_code = 'ALC'
188: AND GLR.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
189: AND GLR.application_id = n_appl_id
207: -- ledgers (which is generally not the case), we will return the first row
208: -- found.
209: SELECT source_ledger_id
210: INTO l_src_ledger_id
211: FROM GL_LEDGER_RELATIONSHIPS GLR,
212: gl_ledgers lgr_c
213: WHERE GLR.target_ledger_id = n_ledger_id
214: AND GLR.target_ledger_category_code = 'SECONDARY'
215: AND GLR.relationship_type_code <> 'NONE'
254: -- ledgers (which is generally not the case), we will return the first row
255: -- found.
256: SELECT source_ledger_id
257: INTO l_src_ledger_id
258: FROM GL_LEDGER_RELATIONSHIPS GLR
259: WHERE GLR.target_ledger_id = n_ledger_id
260: AND GLR.target_ledger_category_code = 'ALC'
261: AND GLR.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
262: AND GLR.relationship_enabled_flag = 'Y'
268: -- ledgers (which is generally not the case), we will return the first row
269: -- found.
270: SELECT source_ledger_id
271: INTO l_src_ledger_id
272: FROM GL_LEDGER_RELATIONSHIPS GLR,
273: GL_LEDGERS LGR_C
274: WHERE GLR.target_ledger_id = n_ledger_id
275: AND GLR.target_ledger_category_code = 'SECONDARY'
276: AND GLR.relationship_type_code <> 'NONE'
328: -- In case if one ALC ledger is attached to multiple primary ledgers
329: -- (which is generally not the case), we will return the first row found.
330: SELECT primary_ledger_id
331: INTO l_pri_ledger_id
332: FROM GL_LEDGER_RELATIONSHIPS
333: WHERE target_ledger_id = n_ledger_id
334: AND target_ledger_category_code = 'ALC'
335: AND relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
336: AND application_id = n_appl_id
343: -- In case if one secondary ledger is attached to multiple primary ledgers
344: -- (which is generally not the case), we will return the first row found.
345: SELECT primary_ledger_id
346: INTO l_pri_ledger_id
347: FROM GL_LEDGER_RELATIONSHIPS GLR,
348: GL_LEDGERS lgr_c
349: WHERE target_ledger_id = n_ledger_id
350: AND target_ledger_category_code = 'SECONDARY'
351: AND relationship_type_code <> 'NONE'
388: -- In case if one ALC ledger is attached to multiple primary ledgers
389: -- (which is generally not the case), we will return the first row found.
390: SELECT primary_ledger_id
391: INTO l_pri_ledger_id
392: FROM GL_LEDGER_RELATIONSHIPS
393: WHERE target_ledger_id = n_ledger_id
394: AND target_ledger_category_code = 'ALC'
395: AND relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
396: AND relationship_enabled_flag = 'Y' -- Should we check if it is enabled???
401: -- In case if one secondary ledger is attached to multiple primary ledgers
402: -- (which is generally not the case), we will return the first row found.
403: SELECT primary_ledger_id
404: INTO l_pri_ledger_id
405: FROM GL_LEDGER_RELATIONSHIPS GLR,
406: GL_LEDGERS lgr_c
407: WHERE target_ledger_id = n_ledger_id
408: AND target_ledger_category_code = 'SECONDARY'
409: AND relationship_type_code <> 'NONE'
513: bsv.LEGAL_ENTITY_ID, le.NAME, bsv.START_DATE,
514: bsv.END_DATE, DECODE(lg.LEDGER_CATEGORY_CODE, 'PRIMARY', 'Y', 'N')
515: -- , bsv.SLA_SEQUENCING_FLAG
516: FROM GL_LEDGERS lg
517: , GL_LEDGER_RELATIONSHIPS rs
518: , GL_LEDGER_NORM_SEG_VALS bsv
519: , XLE_ENTITY_PROFILES le
520: , GL_LEDGERS lgr_c
521: WHERE ((rs.relationship_type_code = 'NONE'
1225: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;
1226: else, based on ORG_ID */
1227: SELECT count(*)
1228: INTO l_count
1229: FROM GL_LEDGER_RELATIONSHIPS GLR
1230: WHERE GLR.source_ledger_id = n_ledger_id
1231: AND GLR.target_ledger_category_code = 'ALC'
1232: AND GLR.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
1233: AND GLR.application_id = n_appl_id
1257: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;
1258: else, based on ORG_ID */
1259: SELECT count(*)
1260: INTO l_count
1261: FROM GL_LEDGER_RELATIONSHIPS GLR
1262: WHERE GLR.target_ledger_id = n_ledger_id
1263: AND GLR.target_ledger_category_code = 'ALC'
1264: AND GLR.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
1265: AND GLR.application_id = n_appl_id
1327: l_count NUMBER;
1328: BEGIN
1329: SELECT count(*)
1330: INTO l_count
1331: FROM GL_LEDGER_RELATIONSHIPS GLR
1332: WHERE GLR.target_ledger_category_code = 'ALC'
1333: AND GLR.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
1334: AND GLR.application_id = n_appl_id
1335: AND GLR.relationship_enabled_flag = 'Y';
1376: BEGIN
1377:
1378: SELECT distinct g.target_ledger_id
1379: BULK COLLECT INTO n_alc_id_list
1380: FROM gl_ledger_relationships g
1381: WHERE g.source_ledger_id = n_src_ledger_id
1382: AND g.target_ledger_category_code = 'ALC'
1383: AND g.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
1384: AND g.relationship_enabled_flag = 'Y';
1547: WHERE ((upper(NVL(n_include_source_ledger, 'Y')) = 'Y'
1548: AND g.ledger_id = l_src_ledger_id)
1549: OR g.ledger_id IN (
1550: SELECT glr.target_ledger_id -- ALC target ledgers
1551: FROM gl_ledger_relationships glr
1552: WHERE glr.source_ledger_id = l_src_ledger_id
1553: AND glr.target_ledger_category_code = 'ALC'
1554: AND glr.relationship_type_code IN ('SUBLEDGER', 'JOURNAL')
1555: AND glr.application_id = n_appl_id
2018: WHERE ((upper(NVL(n_include_primary_ledger, 'Y')) = 'Y'
2019: AND g.ledger_id = l_pri_ledger_id)
2020: OR g.ledger_id IN (
2021: SELECT glr.target_ledger_id -- Secondary Ledgers
2022: FROM gl_ledger_relationships glr, gl_ledgers lgr_c
2023: WHERE glr.primary_ledger_id = l_pri_ledger_id
2024: AND glr.target_ledger_category_code = 'SECONDARY'
2025: AND glr.relationship_type_code <> 'NONE'
2026: AND glr.target_ledger_id = lgr_c.ledger_id