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.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_MG_CONFIGS

Line 33: reported_value jl_co_gl_mg_configs.reported_value%TYPE,

29: literal_id jl_co_gl_mg_literals.literal_id%TYPE,
30: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,
31: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
32: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
33: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
34: nit_id jl_co_gl_nits.nit_id%TYPE,
35: config_id jl_co_gl_mg_configs.config_id%TYPE,
36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
37: range_id jl_co_gl_mg_ranges.range_id%TYPE,

Line 35: config_id jl_co_gl_mg_configs.config_id%TYPE,

31: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
32: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
33: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
34: nit_id jl_co_gl_nits.nit_id%TYPE,
35: config_id jl_co_gl_mg_configs.config_id%TYPE,
36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
37: range_id jl_co_gl_mg_ranges.range_id%TYPE,
38: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
39: origin jl_co_gl_mg_lines.origin%TYPE,

Line 36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,

32: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
33: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
34: nit_id jl_co_gl_nits.nit_id%TYPE,
35: config_id jl_co_gl_mg_configs.config_id%TYPE,
36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
37: range_id jl_co_gl_mg_ranges.range_id%TYPE,
38: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
39: origin jl_co_gl_mg_lines.origin%TYPE,
40: amount jl_co_gl_mg_lines.first_reported_value%TYPE

Line 407: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs

403:
404: x_mg_hdr_count NUMBER;
405:
406: /********************************************************************
407: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs
408: and jl_co_gl_mg_ranges (accounting ranges) tables
409: ********************************************************************/
410:
411: CURSOR literal_cur IS

Line 424: jl_co_gl_mg_configs mgc,

420: mgc.threshold_value rep_threshold_value,
421: mgc.literal_literal_id literal_literal_id,
422: mgr.range_id range_id
423: FROM jl_co_gl_mg_ranges mgr,
424: jl_co_gl_mg_configs mgc,
425: jl_co_gl_mg_literals mgl
426: WHERE mgr.config_id = mgc.config_id
427: AND mgc.literal_id = mgl.literal_id
428: AND mgl.set_of_books_id = p_set_of_books_id

Line 440: CURSOR trx_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,

436: /*************************************************
437: Cursor for selecting rows from jl_co_gl_trx table
438: *************************************************/
439:
440: CURSOR trx_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
441: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS
442:
443: SELECT t.nit_id nit_id,
444: DECODE(x_movement_type,

Line 520: CURSOR bal_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,

516:
517: -- Bug 4018828 - Comment out the join to period_name in the subquery retrieving
518: -- the max period num. This ensures that only the balances for last active
519: -- period for which there exists transactions are taken into account
520: CURSOR bal_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
521: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS
522:
523: SELECT b.nit_id nit_id,
524: DECODE(x_movement_type,

Line 992: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;

988: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
989: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
990: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
991: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
992: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;
993:
994: /************************************
995: Parent Report Group Threshold Cursor
996: ************************************/

Line 1010: FROM jl_co_gl_mg_configs c,

1006: mgl.config_id config_id,
1007: c.threshold_value threshold_value,
1008: SUM(mgl.first_reported_value) first_reported_value,
1009: SUM(mgl.second_reported_value) second_reported_value
1010: FROM jl_co_gl_mg_configs c,
1011: jl_co_gl_mg_literals l,
1012: jl_co_gl_mg_lines mgl,
1013: jl_co_gl_mg_headers mgh
1014: WHERE mgl.mg_header_id = mgh.mg_header_id

Line 1082: FROM jl_co_gl_mg_configs c,

1078:
1079: SELECT mgl.mg_header_id mg_header_id,
1080: mgl.config_id config_id,
1081: mgl.nit_id nit_id
1082: FROM jl_co_gl_mg_configs c,
1083: jl_co_gl_mg_literals l,
1084: jl_co_gl_mg_lines mgl,
1085: jl_co_gl_mg_headers mgh
1086: WHERE mgl.mg_header_id = mgh.mg_header_id

Line 1315: FROM jl_co_gl_mg_configs

1311: UPDATE jl_co_gl_mg_lines
1312: SET reported_flag = 'N'
1313: WHERE mg_header_id = child_threshold_rec.mg_header_id
1314: AND config_id IN (SELECT config_id
1315: FROM jl_co_gl_mg_configs
1316: WHERE config_id_parent = child_threshold_rec.config_id
1317: )
1318: AND nit_id = child_threshold_rec.nit_id;
1319: