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.JA_CN_SYSOPS_BANK_PKG dependencies on GL_LEDGER_CONFIG_DETAILS

Line 54: from gl_ledger_config_details primdet,

50: select xep.legal_entity_id legal_entity_id,
51: xep.name legal_entity_name,
52: lg.ledger_id,
53: rs.primary_ledger_id
54: from gl_ledger_config_details primdet,
55: gl_ledgers lg,
56: gl_ledger_relationships rs,
57: gl_ledger_configurations cfg,
58: gl_ledger_config_details cfgdet,

Line 58: gl_ledger_config_details cfgdet,

54: from gl_ledger_config_details primdet,
55: gl_ledgers lg,
56: gl_ledger_relationships rs,
57: gl_ledger_configurations cfg,
58: gl_ledger_config_details cfgdet,
59: XLE_ENTITY_PROFILES xep
60: where rs.application_id = 101
61: and ((rs.target_ledger_category_code = 'SECONDARY' and
62: rs.relationship_type_code <> 'NONE') or

Line 256: from gl_ledger_config_details primdet,

252:
253: --Legal entity under the ledger
254: CURSOR CUR_LE IS
255: select cfgdet.object_id legal_entity_id
256: from gl_ledger_config_details primdet,
257: gl_ledgers lg,
258: gl_ledger_relationships rs,
259: gl_ledger_configurations cfg,
260: gl_ledger_config_details cfgdet

Line 260: gl_ledger_config_details cfgdet

256: from gl_ledger_config_details primdet,
257: gl_ledgers lg,
258: gl_ledger_relationships rs,
259: gl_ledger_configurations cfg,
260: gl_ledger_config_details cfgdet
261: where rs.application_id = 101
262: and ((rs.target_ledger_category_code = 'SECONDARY' and
263: rs.relationship_type_code <> 'NONE') or
264: (rs.target_ledger_category_code = 'PRIMARY' and

Line 474: from gl_ledger_config_details primdet,

470: ) RETURN BOOLEAN
471: IS
472: CURSOR CUR_LEGAL IS
473: select cfgdet.object_id legal_entity_id
474: from gl_ledger_config_details primdet,
475: gl_ledgers lg,
476: gl_ledger_relationships rs,
477: gl_ledger_configurations cfg,
478: gl_ledger_config_details cfgdet

Line 478: gl_ledger_config_details cfgdet

474: from gl_ledger_config_details primdet,
475: gl_ledgers lg,
476: gl_ledger_relationships rs,
477: gl_ledger_configurations cfg,
478: gl_ledger_config_details cfgdet
479: where rs.application_id = 101
480: and ((rs.target_ledger_category_code = 'SECONDARY' and
481: rs.relationship_type_code <> 'NONE') or
482: (rs.target_ledger_category_code = 'PRIMARY' and