DBA Data[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_TB_DEFN_DETAILS

Line 711: ,xla_tb_defn_details xdd

707: -- commented code from above SQL
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:

Line 1019: ,xla_tb_defn_details xdd

1015: -- commented code from the above SQL
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:

Line 1129: ,xla_tb_defn_details xdd

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
1133: AND xsu.je_source_name = xjs.je_source_name

Line 1510: FROM xla_tb_defn_details tdd

1506: ,gcc.segment29 segment29_from
1507: ,gcc.segment29 segment29_to
1508: ,gcc.segment30 segment30_from
1509: ,gcc.segment30 segment30_to
1510: FROM xla_tb_defn_details tdd
1511: ,gl_code_combinations gcc
1512: WHERE tdd.definition_code = p_definition_code
1513: AND gcc.code_combination_id = tdd.code_combination_id;
1514:

Line 1524: FROM xla_tb_defn_details

1520:
1521: ELSE
1522:
1523: FOR c_segs IN (SELECT DISTINCT flexfield_segment_code
1524: FROM xla_tb_defn_details
1525: WHERE definition_code = p_definition_code)
1526: LOOP
1527: l_seg_num := SUBSTR(c_segs.flexfield_segment_code,8,2);
1528:

Line 1559: -- ,xla_tb_defn_details tab

1555: || C_NEW_LINE;
1556: --
1557: -- Selected Tables
1558: --
1559: -- ,xla_tb_defn_details tab
1560: --
1561: l_tables := l_tables --added for bug9926320
1562: || C_NEW_LINE
1563: || ',xla_tb_defn_details tab'|| l_seg_num

Line 1563: || ',xla_tb_defn_details tab'|| l_seg_num

1559: -- ,xla_tb_defn_details tab
1560: --
1561: l_tables := l_tables --added for bug9926320
1562: || C_NEW_LINE
1563: || ',xla_tb_defn_details tab'|| l_seg_num
1564: || C_NEW_LINE;
1565:
1566: --
1567: -- Join Conditions

Line 1922: DELETE xla_tb_defn_details

1918:
1919: DELETE xla_tb_definitions_tl
1920: WHERE definition_code = p_definition_code;
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;

Line 3176: ,xla_tb_defn_details xdd ';

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)
3180: --