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.

[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_TB_DEFN_JE_SOURCES

Line 565: ,xla_tb_defn_je_sources xjs

561: ,xla_ae_headers PARTITION (AP) xah
562: ,xla_event_types_b xet
563: ,xla_tb_defn_details xdd
564: ,xla_tb_definitions_b xtd
565: ,xla_tb_defn_je_sources xjs
566: ,xla_subledgers xsu
567: ,xla_transaction_entities_upg PARTITION (AP) xteu
568: ,xla_ae_lines PARTITION (AP) xal
569: ,gl_code_combinations gcc

Line 855: ,xla_tb_defn_je_sources xjs

851: ,xla_ae_headers PARTITION (AP) xah
852: ,xla_event_types_b xet
853: ,xla_tb_defn_details xdd
854: ,xla_tb_definitions_b xtd
855: ,xla_tb_defn_je_sources xjs
856: ,xla_subledgers xsu
857: ,xla_transaction_entities_upg PARTITION (AP) xteu
858: ,xla_ae_lines PARTITION (AP) xal
859: ,gl_code_combinations gcc

Line 1083: ,xla_tb_defn_je_sources xjs

1079: ,sysdate
1080: FROM
1081: gl_code_combinations gcc
1082: ,xla_subledgers xsu
1083: ,xla_tb_defn_je_sources xjs
1084: ,xla_tb_defn_details xdd
1085: WHERE xdd.definition_code = :10
1086: AND xdd.owner_code = ''S''
1087: and xdd.code_combination_id = gcc.code_combination_id

Line 1876: DELETE xla_tb_defn_je_sources

1872:
1873: DELETE xla_tb_defn_details
1874: WHERE definition_code = p_definition_code;
1875:
1876: DELETE xla_tb_defn_je_sources
1877: WHERE definition_code = p_definition_code;
1878:
1879: DELETE xla_tb_user_trans_views
1880: WHERE definition_code = p_definition_code;

Line 1896: DELETE xla_tb_defn_je_sources

1892: WHERE definition_code = p_definition_code;
1893:
1894: ELSE
1895:
1896: DELETE xla_tb_defn_je_sources
1897: WHERE definition_code = p_definition_code
1898: AND je_source_name = g_je_source_name;
1899:
1900: DELETE xla_tb_logs

Line 3038: xla_tb_defn_je_sources xjs

3034:
3035:
3036: FOR i IN ( SELECT xsu.application_id
3037: FROM xla_subledgers xsu,
3038: xla_tb_defn_je_sources xjs
3039: WHERE xsu.je_source_name = xjs.je_source_name
3040: AND xjs.definition_code = p_definition_code)
3041: LOOP
3042: l_application_id := i.application_id;

Line 3120: ,xla_tb_defn_je_sources xjs

3116: trace('Defined by Flexfield = ',C_LEVEL_STATEMENT,l_Log_module);
3117: END IF;
3118:
3119: l_from := ',xla_subledgers xsu
3120: ,xla_tb_defn_je_sources xjs
3121: ,xla_tb_defn_details xdd ';
3122:
3123: --
3124: -- Owner Cocde = 'C' (User)

Line 3234: ,xla_tb_defn_je_sources xjs

3230:
3231: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3232:
3233: l_from := ',xla_subledgers xsu
3234: ,xla_tb_defn_je_sources xjs
3235: ,xla_tb_def_seg_ranges xsr ';
3236:
3237: l_where := ' AND xtd.definition_code = :p_definition_code
3238: AND xtd.definition_code = xsr.definition_code

Line 3549: (SELECT distinct je_source_name FROM xla_tb_defn_je_sources) xjs

3545: l_post_programs_where := ' AND xal.accounting_class_code IN (NULL';
3546:
3547: FOR i IN ( SELECT xsu.application_id
3548: FROM xla_subledgers xsu,
3549: (SELECT distinct je_source_name FROM xla_tb_defn_je_sources) xjs
3550: WHERE xsu.je_source_name = xjs.je_source_name
3551: AND xjs.je_source_name = p_je_source_name)
3552: LOOP
3553: l_application_id := i.application_id;

Line 4061: ,xla_tb_defn_je_sources xjs

4057: ) wu
4058: FROM xla_ae_headers aeh
4059: ,xla_subledgers xsu
4060: ,xla_tb_definitions_b xtd
4061: ,xla_tb_defn_je_sources xjs
4062: WHERE gl_transfer_status_code IN ('Y','NT')
4063: AND aeh.ledger_id IN (
4064: SELECT lg.ledger_id
4065: FROM gl_ledgers lg

Line 4109: ,xla_tb_defn_je_sources xjs

4105: ) wu
4106: FROM xla_ae_headers aeh
4107: ,xla_subledgers xsu
4108: ,xla_tb_definitions_b xtd
4109: ,xla_tb_defn_je_sources xjs
4110: WHERE gl_transfer_status_code IN ('Y','NT')
4111: AND aeh.ledger_id = p_ledger_id
4112: AND xtd.definition_code = p_definition_code
4113: AND xtd.definition_code = xjs.definition_code

Line 4167: ,xla_tb_defn_je_sources xjs

4163: ) wu
4164: FROM xla_ae_headers aeh
4165: ,xla_subledgers xsu
4166: ,xla_tb_definitions_b xtd
4167: ,xla_tb_defn_je_sources xjs
4168: WHERE gl_transfer_status_code IN ('Y','NT')
4169: AND aeh.ledger_id IN (
4170: SELECT lg.ledger_id
4171: FROM gl_ledgers lg

Line 4220: ,xla_tb_defn_je_sources xjs

4216: ) wu
4217: FROM xla_ae_headers aeh
4218: ,xla_subledgers xsu
4219: ,xla_tb_definitions_b xtd
4220: ,xla_tb_defn_je_sources xjs
4221: WHERE gl_transfer_status_code IN ('Y','NT')
4222: AND aeh.ledger_id = p_ledger_id
4223: AND xtd.definition_code = p_definition_code
4224: AND xtd.definition_code = xjs.definition_code