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.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_SUBLEDGERS

Line 713: ,xla_subledgers xsu

709: Tables removed from FROM clause:
710: -------------------------------
711: ,xla_tb_defn_details xdd
712: ,xla_tb_defn_je_sources xjs
713: ,xla_subledgers xsu
714: */
715: -- Conditions removed from WHERE clause:
716: -- -------------------------------------
717: /* AND NVL(alb.ae_header_id, alb.sle_header_id) = xah.completion_acct_seq_value

Line 1021: ,xla_subledgers xsu

1017: Tables removed from FROM clause:
1018: --------------------------------
1019: ,xla_tb_defn_details xdd
1020: ,xla_tb_defn_je_sources xjs
1021: ,xla_subledgers xsu
1022: */
1023: -- Conditions removed from WHERE clause:
1024: -------------------------------------
1025: /* AND NVL(alb.ae_header_id, alb.sle_header_id) = xah.completion_acct_seq_value

Line 1127: ,xla_subledgers xsu

1123: ,:9 -- g_program_id
1124: ,sysdate
1125: FROM
1126: gl_code_combinations gcc
1127: ,xla_subledgers xsu
1128: ,xla_tb_defn_je_sources xjs
1129: ,xla_tb_defn_details xdd
1130: WHERE xdd.definition_code = :10
1131: AND xdd.owner_code = ''S''

Line 1687: (p_location => 'xla_subledgers_f_pkg.get_schema');

1683: RAISE;
1684:
1685: WHEN OTHERS THEN
1686: xla_exceptions_pkg.raise_message
1687: (p_location => 'xla_subledgers_f_pkg.get_schema');
1688:
1689: END get_schema;
1690:
1691:

Line 2332: FROM xla_subledgers

2328: BEGIN
2329:
2330: SELECT application_id
2331: INTO g_application_id
2332: FROM xla_subledgers
2333: WHERE je_source_name = g_je_source_name;
2334:
2335: RETURN g_application_id;
2336:

Line 2589: -- xla_subledgers.

2585:
2586: -- Bug#8333978 Changed the select clause to remove the reference of xla_trial_balances
2587: -- table in the from. To get the definition code and application id
2588: -- used the following tables in the join ie xla_tb_defn_je_sources and
2589: -- xla_subledgers.
2590:
2591:
2592: INSERT INTO xla_tb_user_trans_views
2593: (definition_code

Line 2628: xla_subledgers xsu,

2624: ,g_prog_appl_id
2625: ,g_program_id
2626: ,SYSDATE
2627: FROM
2628: xla_subledgers xsu,
2629: xla_tb_defn_je_sources xjs,
2630: xla_event_class_attrs xeca
2631: WHERE xeca.event_class_code <> 'MANUAL'
2632: AND xeca.application_id = xsu.application_id

Line 2719: -- xla_subledgers.

2715:
2716: -- Bug#8333978 Changed the select clause to remove the reference of xla_trial_balances
2717: -- table in the from clause. To get the definition code and application id
2718: -- used the following tables in the join ie xla_tb_defn_je_sources and
2719: -- xla_subledgers.
2720:
2721: INSERT INTO xla_tb_user_trans_views
2722: (definition_code
2723: ,application_id

Line 2756: FROM xla_subledgers xsu,

2752: ,g_request_id
2753: ,g_prog_appl_id
2754: ,g_program_id
2755: ,SYSDATE
2756: FROM xla_subledgers xsu,
2757: xla_tb_defn_je_sources xjs,
2758: xla_event_class_attrs xeca
2759: WHERE xeca.event_class_code <> 'MANUAL'
2760: AND xsu.application_id = xeca.application_id

Line 3092: FROM xla_subledgers xsu,

3088: l_post_programs_where := ' AND xal.accounting_class_code IN (NULL';
3089:
3090:
3091: FOR i IN ( SELECT xsu.application_id
3092: FROM xla_subledgers xsu,
3093: xla_tb_defn_je_sources xjs
3094: WHERE xsu.je_source_name = xjs.je_source_name
3095: AND xjs.definition_code = p_definition_code)
3096: LOOP

Line 3174: l_from := ',xla_subledgers xsu

3170: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3171: trace('Defined by Flexfield = ',C_LEVEL_STATEMENT,l_Log_module);
3172: END IF;
3173:
3174: l_from := ',xla_subledgers xsu
3175: ,xla_tb_defn_je_sources xjs
3176: ,xla_tb_defn_details xdd ';
3177:
3178: --

Line 3316: l_from := ',xla_subledgers xsu

3312: END IF;
3313:
3314: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3315:
3316: l_from := ',xla_subledgers xsu
3317: ,xla_tb_defn_je_sources xjs
3318: ,xla_tb_def_seg_ranges xsr ';
3319:
3320: l_where := ' AND xtd.definition_code = :p_definition_code

Line 3701: FROM xla_subledgers xsu,

3697:
3698: l_post_programs_where := ' AND xal.accounting_class_code IN (NULL';
3699:
3700: FOR i IN ( SELECT xsu.application_id
3701: FROM xla_subledgers xsu,
3702: (SELECT distinct je_source_name FROM xla_tb_defn_je_sources) xjs
3703: WHERE xsu.je_source_name = xjs.je_source_name
3704: AND xjs.je_source_name = p_je_source_name)
3705: LOOP

Line 4212: ,xla_subledgers xsu

4208: ROWS unbounded preceding
4209: )/C_WORK_UNIT
4210: ) wu
4211: FROM xla_ae_headers aeh
4212: ,xla_subledgers xsu
4213: ,xla_tb_definitions_b xtd
4214: ,xla_tb_defn_je_sources xjs
4215: WHERE gl_transfer_status_code IN ('Y','NT')
4216: AND aeh.ledger_id IN (

Line 4260: ,xla_subledgers xsu

4256: ROWS unbounded preceding
4257: )/C_WORK_UNIT
4258: ) wu
4259: FROM xla_ae_headers aeh
4260: ,xla_subledgers xsu
4261: ,xla_tb_definitions_b xtd
4262: ,xla_tb_defn_je_sources xjs
4263: WHERE gl_transfer_status_code IN ('Y','NT')
4264: AND aeh.ledger_id = p_ledger_id

Line 4318: ,xla_subledgers xsu

4314: ROWS unbounded preceding
4315: )/C_WORK_UNIT
4316: ) wu
4317: FROM xla_ae_headers aeh
4318: ,xla_subledgers xsu
4319: ,xla_tb_definitions_b xtd
4320: ,xla_tb_defn_je_sources xjs
4321: WHERE gl_transfer_status_code IN ('Y','NT')
4322: AND aeh.ledger_id IN (

Line 4371: ,xla_subledgers xsu

4367: ROWS unbounded preceding
4368: )/C_WORK_UNIT
4369: ) wu
4370: FROM xla_ae_headers aeh
4371: ,xla_subledgers xsu
4372: ,xla_tb_definitions_b xtd
4373: ,xla_tb_defn_je_sources xjs
4374: WHERE gl_transfer_status_code IN ('Y','NT')
4375: AND aeh.ledger_id = p_ledger_id