[Home] [Help]
708: /*
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: -- -------------------------------------
1016: /*
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: -------------------------------------
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''
1132: and xdd.code_combination_id = gcc.code_combination_id
1921:
1922: DELETE xla_tb_defn_details
1923: WHERE definition_code = p_definition_code;
1924:
1925: DELETE xla_tb_defn_je_sources
1926: WHERE definition_code = p_definition_code;
1927:
1928: DELETE xla_tb_user_trans_views
1929: WHERE definition_code = p_definition_code;
1941: WHERE definition_code = p_definition_code;
1942:
1943: ELSE
1944:
1945: DELETE xla_tb_defn_je_sources
1946: WHERE definition_code = p_definition_code
1947: AND je_source_name = g_je_source_name;
1948:
1949: DELETE xla_tb_logs
2584: --perf imp 13-may-2008
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
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
2633: AND xsu.je_source_name = xjs.je_source_name
2714: ELSE
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
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
2761: AND xsu.je_source_name = xjs.je_source_name
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
3097: l_application_id := i.application_id;
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: --
3179: -- Owner Cocde = 'C' (User)
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
3321: AND xtd.definition_code = xsr.definition_code
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
3706: l_application_id := i.application_id;
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 (
4217: SELECT lg.ledger_id
4218: FROM gl_ledgers lg
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
4265: AND xtd.definition_code = p_definition_code
4266: AND xtd.definition_code = xjs.definition_code
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 (
4323: SELECT lg.ledger_id
4324: FROM gl_ledgers lg
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
4376: AND xtd.definition_code = p_definition_code
4377: AND xtd.definition_code = xjs.definition_code