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_MC_INFO dependencies on GL_LEDGERS

Line 18: FROM gl_ledgers

14: n_ledger_currency := pg_ledger_currency_rec(n_ledger_id);
15: ELSE
16: SELECT currency_code
17: INTO n_ledger_currency
18: FROM gl_ledgers
19: WHERE ledger_id = n_ledger_id;
20:
21: pg_ledger_currency_rec(n_ledger_id) := n_ledger_currency;
22: END IF;

Line 43: FROM gl_ledgers

39: n_alc_ledger_type := pg_alc_ledger_type_rec(n_ledger_id);
40: ELSE
41: SELECT alc_ledger_type_code
42: INTO n_alc_ledger_type
43: FROM gl_ledgers
44: WHERE ledger_id = n_ledger_id;
45:
46: pg_alc_ledger_type_rec(n_ledger_id) := n_alc_ledger_type;
47: END IF;

Line 67: FROM gl_ledgers

63: RETURN pg_alc_ledger_type_rec(n_ledger_id);
64: ELSE
65: SELECT alc_ledger_type_code
66: INTO l_alc_ledger_type
67: FROM gl_ledgers
68: WHERE ledger_id = n_ledger_id;
69:
70: pg_alc_ledger_type_rec(n_ledger_id) := l_alc_ledger_type;
71: RETURN l_alc_ledger_type;

Line 123: FROM gl_ledgers

119: n_ledger_category := pg_ledger_category_rec(n_ledger_id);
120: ELSE
121: SELECT ledger_category_code
122: INTO n_ledger_category
123: FROM gl_ledgers
124: WHERE ledger_id = n_ledger_id;
125:
126: pg_ledger_category_rec(n_ledger_id) := n_ledger_category;
127: END IF;

Line 147: FROM gl_ledgers

143: RETURN pg_ledger_category_rec(n_ledger_id);
144: ELSE
145: SELECT ledger_category_code
146: INTO l_ledger_category
147: FROM gl_ledgers
148: WHERE ledger_id = n_ledger_id;
149:
150: pg_ledger_category_rec(n_ledger_id) := l_ledger_category;
151: RETURN l_ledger_category;

Line 169: l_src_ledger_id gl_ledgers.ledger_id%TYPE;

165: FUNCTION get_source_ledger_id (n_ledger_id IN NUMBER,
166: n_appl_id IN NUMBER,
167: n_org_id IN NUMBER,
168: n_fa_book_code IN VARCHAR2) RETURN NUMBER IS
169: l_src_ledger_id gl_ledgers.ledger_id%TYPE;
170: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
171: BEGIN
172: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
173:

Line 170: l_ledger_category gl_ledgers.ledger_category_code%TYPE;

166: n_appl_id IN NUMBER,
167: n_org_id IN NUMBER,
168: n_fa_book_code IN VARCHAR2) RETURN NUMBER IS
169: l_src_ledger_id gl_ledgers.ledger_id%TYPE;
170: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
171: BEGIN
172: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
173:
174: IF (l_ledger_category = 'PRIMARY')

Line 212: gl_ledgers lgr_c

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'
216: AND GLR.application_id = n_appl_id

Line 242: l_src_ledger_id gl_ledgers.ledger_id%TYPE;

238: -- Return the ALC source ledger ID of the particular ALC target ledger
239: -- History
240: -- 25-FEB-03 LPOON Created (New R11i.X function)
241: FUNCTION get_source_ledger_id (n_ledger_id IN NUMBER) RETURN NUMBER IS
242: l_src_ledger_id gl_ledgers.ledger_id%TYPE;
243: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
244: BEGIN
245: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
246:

Line 243: l_ledger_category gl_ledgers.ledger_category_code%TYPE;

239: -- History
240: -- 25-FEB-03 LPOON Created (New R11i.X function)
241: FUNCTION get_source_ledger_id (n_ledger_id IN NUMBER) RETURN NUMBER IS
242: l_src_ledger_id gl_ledgers.ledger_id%TYPE;
243: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
244: BEGIN
245: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
246:
247: IF (l_ledger_category = 'PRIMARY')

Line 273: GL_LEDGERS LGR_C

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'
277: AND GLR.relationship_enabled_flag = 'Y'

Line 317: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;

313: -- 25-FEB-03 LPOON Created (New R11i.X function)
314: FUNCTION get_primary_ledger_id (n_ledger_id IN NUMBER,
315: n_appl_id IN NUMBER,
316: n_org_id IN NUMBER) RETURN NUMBER IS
317: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;
318: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
319: BEGIN
320: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
321:

Line 318: l_ledger_category gl_ledgers.ledger_category_code%TYPE;

314: FUNCTION get_primary_ledger_id (n_ledger_id IN NUMBER,
315: n_appl_id IN NUMBER,
316: n_org_id IN NUMBER) RETURN NUMBER IS
317: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;
318: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
319: BEGIN
320: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
321:
322: IF (l_ledger_category = 'PRIMARY')

Line 348: GL_LEDGERS lgr_c

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'
352: AND application_id = n_appl_id

Line 377: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;

373: -- Return the Primary ledger ID of the particular Secondary ledger ID
374: -- History
375: -- 25-FEB-03 LPOON Created (New R11i.X function)
376: FUNCTION get_primary_ledger_id (n_ledger_id IN NUMBER) RETURN NUMBER IS
377: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;
378: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
379: BEGIN
380: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
381:

Line 378: l_ledger_category gl_ledgers.ledger_category_code%TYPE;

374: -- History
375: -- 25-FEB-03 LPOON Created (New R11i.X function)
376: FUNCTION get_primary_ledger_id (n_ledger_id IN NUMBER) RETURN NUMBER IS
377: l_pri_ledger_id gl_ledgers.ledger_id%TYPE;
378: l_ledger_category gl_ledgers.ledger_category_code%TYPE;
379: BEGIN
380: l_ledger_category := gl_mc_info.get_ledger_category(n_ledger_id);
381:
382: IF (l_ledger_category = 'PRIMARY')

Line 406: GL_LEDGERS lgr_c

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'
410: AND relationship_enabled_flag = 'Y' -- Should we check if it is enabled???

Line 467: FROM GL_LEDGERS

463: bal_seg_value_set_id
464: INTO l_ledger_category,
465: l_bsv_option,
466: l_bsv_vset_id
467: FROM GL_LEDGERS
468: WHERE ledger_id = p_ledger_id;
469:
470: IF (l_ledger_category <> 'PRIMARY'
471: AND l_ledger_category <> 'SECONDARY'

Line 516: FROM GL_LEDGERS lg

512: lg.BAL_SEG_VALUE_SET_ID, lg.BAL_SEG_COLUMN_NAME, bsv.SEGMENT_VALUE,
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

Line 520: , GL_LEDGERS lgr_c

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'
522: AND rs.target_ledger_id = p_ledger_id)
523: OR
524: (rs.target_ledger_category_code = 'ALC'

Line 617: 'FROM GL_LEDGERS lg, '|| l_fv_table || ' bsv ';

613:
614: -- Build FROM statement of the dynamic INSERT SQL
615: l_line_no := l_line_no + 1;
616: l_insertSQL(l_line_no) :=
617: 'FROM GL_LEDGERS lg, '|| l_fv_table || ' bsv ';
618:
619: -- Build WHERE statement of the dynamic INSERT SQL
620: l_line_no := l_line_no + 1;
621: l_insertSQL(l_line_no) :=

Line 838: FROM GL_LEDGERS

834: END IF;
835:
836: SELECT NVL(bal_seg_value_option_code,'A')
837: INTO l_bal_seg_opt
838: FROM GL_LEDGERS
839: WHERE ledger_id = p_ledger_id;
840:
841: /*
842: * Bug 6810738

Line 997: GL_LEDGERS lg

993: -- ledger ID
994: SELECT lg.LEDGER_ID
995: INTO l_ledger_id
996: FROM GL_LEDGER_CONFIG_DETAILS cfDet,
997: GL_LEDGERS lg
998: WHERE cfDet.OBJECT_ID = p_legal_entity_id
999: AND cfDet.OBJECT_TYPE_CODE = 'LEGAL_ENTITY'
1000: AND lg.CONFIGURATION_ID = cfDet.CONFIGURATION_ID
1001: AND lg.LEDGER_CATEGORY_CODE = 'PRIMARY';

Line 1013: FROM GL_LEDGERS

1009:
1010: -- Check if it allows all BSV or specific BSV
1011: SELECT DECODE(bal_seg_value_option_code, 'I', 'N', 'Y')
1012: INTO x_allow_all_bsv_flag
1013: FROM GL_LEDGERS
1014: WHERE ledger_id = l_ledger_id;
1015:
1016: -- Initialize GL_LEGDER_LE_BSV_GT before getting its assigned BSV
1017: l_ret_value := GL_MC_INFO.init_ledger_le_bsv_gt(l_ledger_id);

Line 1544: FROM gl_ledgers g,

1540: l_ledger_rec_col.r_precision,
1541: l_ledger_rec_col.r_mau,
1542: l_ledger_rec_col.r_sob_type,
1543: l_ledger_rec_col.r_sob_user_type
1544: FROM gl_ledgers g,
1545: fnd_currencies f
1546: -- Include ALC source ledger if n_include_source_ledger = 'Y' or NULL
1547: WHERE ((upper(NVL(n_include_source_ledger, 'Y')) = 'Y'
1548: AND g.ledger_id = l_src_ledger_id)

Line 2015: FROM gl_ledgers g,

2011: l_ledger_rec_col.r_precision,
2012: l_ledger_rec_col.r_mau,
2013: l_ledger_rec_col.r_sob_type,
2014: l_ledger_rec_col.r_sob_user_type
2015: FROM gl_ledgers g,
2016: fnd_currencies f
2017: -- Include primary ledger only if n_include_primary_ledger is Y or NULL
2018: WHERE ((upper(NVL(n_include_primary_ledger, 'Y')) = 'Y'
2019: AND g.ledger_id = l_pri_ledger_id)

Line 2022: FROM gl_ledger_relationships glr, gl_ledgers lgr_c

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

Line 2123: FROM gl_ledgers

2119: BEGIN
2120: SELECT currency_code, name
2121: INTO ael_sob_info(j).currency_code,
2122: ael_sob_info(j).sob_name
2123: FROM gl_ledgers
2124: WHERE ledger_id = l_aa(l_cnt).sob_id;
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');

Line 2129: fnd_message.set_token('TABLE','GL_LEDGERS');

2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
2128: fnd_message.set_token('MODULE','GLMCINFB');
2129: fnd_message.set_token('TABLE','GL_LEDGERS');
2130: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
2131: END;
2132:
2133: ael_sob_info(j).sob_id := l_aa(l_cnt).sob_id;

Line 2356: , gl_ledgers gl

2352: , l_fv_type
2353: , l_fv_description
2354: FROM fnd_flex_value_sets fvs
2355: , fnd_flex_validation_tables fvt
2356: , gl_ledgers gl
2357: WHERE fvs.flex_value_set_id = gl.bal_seg_value_set_id
2358: AND gl.ledger_id = n_ledger_id
2359: AND fvt.flex_value_set_id = fvs.flex_value_set_id;
2360: EXCEPTION

Line 2379: FROM GL_LEDGERS Ledgers,

2375: )
2376: SELECT FlexValues.FLEX_VALUE,
2377: FlexValues.DESCRIPTION,
2378: n_ledger_id
2379: FROM GL_LEDGERS Ledgers,
2380: FND_FLEX_VALUES_VL FlexValues
2381: WHERE FlexValues.FLEX_VALUE_SET_ID = Ledgers.bal_seg_value_set_id
2382: AND Ledgers.ledger_id = n_ledger_id
2383: AND FlexValues.SUMMARY_FLAG = 'N';