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_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_CONS_FLEX_HIERARCHIES

Line 4082: l_referential_account gl_cons_flex_hierarchies.parent_flex_value%TYPE;

4078: END register_I050;
4079:
4080: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE ) AS
4081: l_institution_resp_code VARCHAR2(250);
4082: l_referential_account gl_cons_flex_hierarchies.parent_flex_value%TYPE;
4083: l_cnt NUMBER;
4084: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I051';
4085: BEGIN
4086:

Line 4105: ,gl_cons_flex_hierarchies ch

4101:
4102: SELECT count(distinct parent_flex_value) into l_cnt
4103: FROM gl_coa_mappings C
4104: ,gl_cons_segment_map cm
4105: ,gl_cons_flex_hierarchies ch
4106: WHERE c.coa_mapping_id = g_coa_mapping_id
4107: AND cm.coa_mapping_id = c.coa_mapping_id
4108: AND cm.segment_map_type = 'R' --Detail Rollup Ranges
4109: AND cm.segment_map_id = ch.segment_map_id

Line 4137: ,gl_cons_flex_hierarchies ch

4133: SELECT parent_flex_value into l_referential_account
4134: FROM (SELECT ch.parent_flex_value
4135: FROM gl_coa_mappings C
4136: ,gl_cons_segment_map cm
4137: ,gl_cons_flex_hierarchies ch
4138: WHERE c.coa_mapping_id = g_coa_mapping_id
4139: AND cm.coa_mapping_id = c.coa_mapping_id
4140: AND cm.segment_map_type = 'R' --Detail Rollup Ranges
4141: AND cm.segment_map_id = ch.segment_map_id