APPS.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_SUBLEDGERS

Line 566: ,xla_subledgers xsu

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
570: ,( SELECT /*+ NO_MERGE*/ id_flex_num

Line 856: ,xla_subledgers xsu

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
860: ,( SELECT /*+ NO_MERGE*/ id_flex_num

Line 1082: ,xla_subledgers xsu

1078: ,:9 -- g_program_id
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''

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

1634: RAISE;
1635:
1636: WHEN OTHERS THEN
1637: xla_exceptions_pkg.raise_message
1638: (p_location => 'xla_subledgers_f_pkg.get_schema');
1639:
1640: END get_schema;
1641:
1642:

Line 2283: FROM xla_subledgers

2279: BEGIN
2280:
2281: SELECT application_id
2282: INTO g_application_id
2283: FROM xla_subledgers
2284: WHERE je_source_name = g_je_source_name;
2285:
2286: RETURN g_application_id;
2287:

Line 3037: FROM xla_subledgers xsu,

3033: l_post_programs_where := ' AND xal.accounting_class_code IN (NULL';
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

Line 3119: l_from := ',xla_subledgers xsu

3115: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
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: --

Line 3233: l_from := ',xla_subledgers xsu

3229: END IF;
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

Line 3548: FROM xla_subledgers xsu,

3544:
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

Line 4059: ,xla_subledgers xsu

4055: ROWS unbounded preceding
4056: )/C_WORK_UNIT
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 (

Line 4107: ,xla_subledgers xsu

4103: ROWS unbounded preceding
4104: )/C_WORK_UNIT
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

Line 4165: ,xla_subledgers xsu

4161: ROWS unbounded preceding
4162: )/C_WORK_UNIT
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 (

Line 4218: ,xla_subledgers xsu

4214: ROWS unbounded preceding
4215: )/C_WORK_UNIT
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