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.

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on XLA_AE_LINES

Line 104: ' as select * from XLA_AE_LINES where rownum<1 ';

100: ' add datafix_update_date date default sysdate';
101:
102: Execute Immediate
103: 'create table '||'LINES_'||P_Bug_Number||
104: ' as select * from XLA_AE_LINES where rownum<1 ';
105:
106: Execute Immediate
107: 'alter table '||'LINES_'||P_Bug_Number||
108: ' add datafix_update_date date default sysdate';

Line 304: ' select '||col_str2||' from xla_ae_lines '||

300: EXECUTE IMMEDIATE sql_liab_stat ;
301:
302: l_debug_info := 'Before backing the lines';
303: sql_liab_stat := 'insert into lines_'||P_Bug_Number||'('||col_str2||') '||
304: ' select '||col_str2||' from xla_ae_lines '||
305: ' where ae_header_id in '||
306: ' (select xah.ae_header_id '||
307: ' from headers_'||P_Bug_Number||' xah, '||
308: l_driver_table||' dr '||

Line 1716: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;

1712: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
1718: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

1713: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
1718: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1721: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

Line 1784: ' xla_ae_lines xal, '||

1780: ' glcc.end_date_active, '||
1781: ' gl.name '||
1782: ' FROM xla_events xe, '||
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 '||

Line 2623: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

2619: undo_failures REFCURTYP;
2620:
2621: TYPE kind_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
2622: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
2623: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
2624: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2625: TYPE event_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2626: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
2627: TYPE balance_type_code_t IS TABLE OF XLA_AE_HEADERS.BALANCE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;

2628: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
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;

Line 2634: TYPE entered_dr_t IS TABLE OF XLA_AE_LINES.ENTERED_DR%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;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 2635: TYPE entered_cr_t IS TABLE OF XLA_AE_LINES.ENTERED_CR%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;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;

Line 2636: TYPE accounted_dr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_DR%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;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 2637: TYPE accounted_cr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_CR%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;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%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;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
2642: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Line 2929: ' xla_ae_lines xal, '||

2925: ' xal.description, '||
2926: ' gl.name '||
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 '||

Line 2974: ' xla_ae_lines xal, '||

2970: ' xal.description, '||
2971: ' gl.name '||
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 '||

Line 3557: xla_ae_lines xal

3553: INTO l_count_hist_pay
3554: FROM ap_invoice_payments_all aip,
3555: xla_ae_headers xah,
3556: xla_transaction_entities_upg xte,
3557: xla_ae_lines xal
3558: WHERE xah.application_id = 200
3559: AND aip.check_id = nvl(xte.source_id_int_1, -99)
3560: AND aip.set_of_books_id = xte.ledger_id
3561: AND xte.entity_code = 'AP_PAYMENTS'

Line 3753: xla_ae_lines xal

3749: AND nvl(aid.reversal_flag, 'N') <> 'Y')
3750: AND EXISTS
3751: (SELECT 1
3752: FROM xla_ae_headers xah,
3753: xla_ae_lines xal
3754: WHERE xah.application_id = 200
3755: AND xal.application_id = 200
3756: AND xah.event_id = xe.event_id
3757: AND xah.ae_header_id = xal.ae_header_id

Line 6081: FROM xla_ae_lines xal,

6077: l_total_prepay_acct NUMBER := -100;
6078: BEGIN
6079: SELECT NVL((sum(nvl(xal.entered_dr, 0) - nvl(xal.entered_cr, 0))), 0) --bug12764043, removed ABS
6080: into l_total_prepay_acct
6081: FROM xla_ae_lines xal,
6082: xla_ae_headers xah
6083: WHERE xal.application_id = 200
6084: AND xah.application_id = 200
6085: AND xah.balance_type_code = 'A' --bug12654609

Line 6110: FROM xla_ae_lines xal,

6106:
6107:
6108: SELECT NVL((sum(nvl(xal.entered_dr, 0) - nvl(xal.entered_cr, 0))), 0) --bug12764043, removed ABS
6109: into l_total_prepay_acct
6110: FROM xla_ae_lines xal,
6111: xla_ae_headers xah
6112: WHERE xal.application_id = 200
6113: AND xah.application_id = 200
6114: AND xah.balance_type_code = 'A' --bug12654609