[Home] [Help]
1783: ' xla_ae_headers xah, '||
1784: ' xla_ae_lines xal, '||
1785: l_driver_table||' dr, '||
1786: ' xla_transaction_entities_upg xte, '||
1787: ' gl_code_combinations_kfv glcc, '||
1788: ' gl_ledgers gl '||
1789: ' WHERE xe.application_id = 200 '||
1790: ' AND xah.application_id = 200 '||
1791: ' AND xal.application_id = 200 '||
2629: TYPE org_id_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
2633: TYPE padded_concatenated_segments_t IS TABLE OF GL_CODE_COMBINATIONS_KFV.PADDED_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
2634: TYPE entered_dr_t IS TABLE OF XLA_AE_LINES.ENTERED_DR%TYPE INDEX BY BINARY_INTEGER;
2635: TYPE entered_cr_t IS TABLE OF XLA_AE_LINES.ENTERED_CR%TYPE INDEX BY BINARY_INTEGER;
2636: TYPE accounted_dr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_DR%TYPE INDEX BY BINARY_INTEGER;
2637: TYPE accounted_cr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_CR%TYPE INDEX BY BINARY_INTEGER;
2927: ' FROM xla_events xe, '||
2928: ' xla_ae_headers xah, '||
2929: ' xla_ae_lines xal, '||
2930: ' xla_transaction_entities_upg xte, '||
2931: ' gl_code_combinations_kfv gcc, '||
2932: ' gl_ledgers gl '||
2933: ' WHERE xe.application_id = 200 '||
2934: ' AND xah.application_id = 200 '||
2935: ' AND xal.application_id = 200 '||
2972: ' FROM xla_events xe, '||
2973: ' xla_ae_headers xah, '||
2974: ' xla_ae_lines xal, '||
2975: ' xla_transaction_entities_upg xte, '||
2976: ' gl_code_combinations_kfv gcc, '||
2977: ' gl_ledgers gl '||
2978: ' WHERE xe.application_id = 200 '||
2979: ' AND xah.application_id = 200 '||
2980: ' AND xal.application_id = 200 '||