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 42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,

38: literal_id jl_co_gl_mg_literals.literal_id%TYPE,
39: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,
40: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,

Line 44: config_id jl_co_gl_mg_configs.config_id%TYPE,

40: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
48: origin jl_co_gl_mg_lines.origin%TYPE,

Line 45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,

41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
48: origin jl_co_gl_mg_lines.origin%TYPE,
49: amount jl_co_gl_mg_lines.first_reported_value%TYPE

Line 461: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs

457:
458: x_mg_hdr_count NUMBER;
459:
460: /********************************************************************
461: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs
462: and jl_co_gl_mg_ranges (accounting ranges) tables
463: ********************************************************************/
464:
465: CURSOR literal_cur IS

Line 478: jl_co_gl_mg_configs mgc,

474: mgc.threshold_value rep_threshold_value,
475: mgc.literal_literal_id literal_literal_id,
476: mgr.range_id range_id
477: FROM jl_co_gl_mg_ranges mgr,
478: jl_co_gl_mg_configs mgc,
479: jl_co_gl_mg_literals mgl
480: WHERE mgr.config_id = mgc.config_id
481: AND mgc.literal_id = mgl.literal_id
482: AND mgl.set_of_books_id = p_set_of_books_id

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

490: /*************************************************
491: Cursor for selecting rows from jl_co_gl_trx table
492: *************************************************/
493:
494: CURSOR trx_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
495: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS
496:
497: SELECT t.nit_id nit_id,
498: DECODE(x_movement_type,

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

573:
574: -- Bug 4018828 - Comment out the join to period_name in the subquery retrieving
575: -- the max period num. This ensures that only the balances for last active
576: -- period for which there exists transactions are taken into account
577: CURSOR bal_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
578: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS
579:
580: SELECT b.nit_id nit_id,
581: DECODE(x_movement_type,

Line 1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;

1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;
1051:
1052: /************************************
1053: Parent Report Group Threshold Cursor
1054: ************************************/

Line 1075: FROM jl_co_gl_mg_configs c,

1071: SUM(mgl.sixth_reported_value) sixth_reported_value,
1072: SUM(mgl.seventh_reported_value) seventh_reported_value,
1073: SUM(mgl.eighth_reported_value) eighth_reported_value,
1074: SUM(mgl.ninth_reported_value) ninth_reported_value
1075: FROM jl_co_gl_mg_configs c,
1076: jl_co_gl_mg_literals l,
1077: jl_co_gl_mg_lines mgl,
1078: jl_co_gl_mg_headers mgh
1079: WHERE mgl.mg_header_id = mgh.mg_header_id

Line 1157: FROM jl_co_gl_mg_configs c,

1153:
1154: SELECT mgl.mg_header_id mg_header_id,
1155: mgl.config_id config_id,
1156: mgl.nit_id nit_id
1157: FROM jl_co_gl_mg_configs c,
1158: jl_co_gl_mg_literals l,
1159: jl_co_gl_mg_lines mgl,
1160: jl_co_gl_mg_headers mgh
1161: WHERE mgl.mg_header_id = mgh.mg_header_id

Line 1420: FROM jl_co_gl_mg_configs

1416: UPDATE jl_co_gl_mg_lines
1417: SET reported_flag = 'N'
1418: WHERE mg_header_id = child_threshold_rec.mg_header_id
1419: AND config_id IN (SELECT config_id
1420: FROM jl_co_gl_mg_configs
1421: WHERE config_id_parent = child_threshold_rec.config_id
1422: )
1423: AND nit_id = child_threshold_rec.nit_id;
1424: