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_HEADERS

Line 96: ' as select * from XLA_AE_HEADERS where rownum<1 ';

92: ' add datafix_update_date date default sysdate';
93:
94: Execute Immediate
95: 'create table '||'HEADERS_'||P_Bug_Number||
96: ' as select * from XLA_AE_HEADERS where rownum<1 ';
97:
98: Execute Immediate
99: 'alter table '||'HEADERS_'||P_Bug_Number||
100: ' add datafix_update_date date default sysdate';

Line 295: ' select '||col_str1||' from xla_ae_headers '||

291: EXECUTE IMMEDIATE sql_liab_stat ;
292:
293: l_debug_info := 'Before backing the headers';
294: sql_liab_stat := 'insert into headers_'||P_Bug_Number||'('||col_str1||') '||
295: ' select '||col_str1||' from xla_ae_headers '||
296: ' where event_id in '||
297: ' (select event_id from '||l_driver_table||
298: ' Where process_flag=''Y'')';
299:

Line 714: l_gl_transfer_status_code XLA_AE_HEADERS.GL_TRANSFER_STATUS_CODE%TYPE;

710: p_commit_flag IN VARCHAR2,
711: p_calling_sequence IN VARCHAR2) IS
712:
713: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
714: l_gl_transfer_status_code XLA_AE_HEADERS.GL_TRANSFER_STATUS_CODE%TYPE;
715: l_debug_info VARCHAR2(4000);
716: l_error_log LONG;
717: l_calling_sequence VARCHAR2(4000);
718:

Line 827: FROM xla_ae_headers xah

823: AND xe.event_id = p_event_id;
824:
825: SELECT xah.gl_transfer_status_code
826: INTO l_gl_transfer_status_code
827: FROM xla_ae_headers xah
828: WHERE xah.application_id = 200
829: AND xah.gl_transfer_status_code = 'Y'
830: AND xah.event_id = p_event_id
831: AND rownum = 1;

Line 929: FROM xla_ae_headers

925: INTO l_journals_exist
926: FROM dual
927: WHERE EXISTS
928: (SELECT 'JOURNALS EXISTS'
929: FROM xla_ae_headers
930: WHERE application_id =200
931: AND event_id = p_event_id);
932: EXCEPTION
933:

Line 1102: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

1098:
1099: TYPE refcurtyp IS REF CURSOR;
1100: closed_period_trx REFCURTYP;
1101:
1102: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

1099: TYPE refcurtyp IS REF CURSOR;
1100: closed_period_trx REFCURTYP;
1101:
1102: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

Line 1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

1100: closed_period_trx REFCURTYP;
1101:
1102: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

1101:
1102: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

Line 1234: ' xla_ae_headers xah, '||

1230: ' ''N'', ''Never Opened'', '||
1231: ' ''Not-Open''), '||
1232: ' gl.name '||
1233: ' FROM xla_events xe, '||
1234: ' xla_ae_headers xah, '||
1235: l_driver_table||' dr, '||
1236: ' xla_transaction_entities_upg xte, '||
1237: ' gl_period_statuses glps, '||
1238: ' gl_ledgers gl '||

Line 1370: ' xla_ae_headers xah, '||

1366: ' ''N'', ''Never Opened'', '||
1367: ' ''Not-Open''), '||
1368: ' gl.name '||
1369: ' FROM xla_events xe, '||
1370: ' xla_ae_headers xah, '||
1371: l_driver_table||' dr, '||
1372: ' xla_transaction_entities_upg xte, '||
1373: ' gl_period_statuses glps, '||
1374: ' gl_ledgers gl '||

Line 1405: ' xla_ae_headers xahe '||

1401: l_sql_stmt := l_sql_stmt||
1402: ' AND EXISTS '||
1403: ' (SELECT 1 '||
1404: ' FROM gl_period_statuses glpse, '||
1405: ' xla_ae_headers xahe '||
1406: ' WHERE xahe.application_id = 200 '||
1407: ' AND (glpse.application_id = 101 OR '||
1408: ' (glpse.application_id = 200 AND '||
1409: ' xahe.ledger_id = xte.ledger_id)) '||

Line 1553: ' xla_ae_headers xah '||

1549: ' AND NOT EXISTS '||
1550: ' (SELECT 1 '||
1551: ' FROM gl_period_statuses glps, '||
1552: ' xla_transaction_entities_upg xte, '||
1553: ' xla_ae_headers xah '||
1554: ' WHERE (glps.application_id = 101 OR '||
1555: ' (glps.application_id = 200 AND '||
1556: ' xah.ledger_id = xte.ledger_id)) '||
1557: ' AND dr.event_id = xah.event_id '||

Line 1607: ' xla_ae_headers xah '||

1603: ' AND NOT EXISTS '||
1604: ' (SELECT 1 '||
1605: ' FROM gl_period_statuses glps, '||
1606: ' xla_transaction_entities_upg xte, '||
1607: ' xla_ae_headers xah '||
1608: ' WHERE (glps.application_id = 101 OR '||
1609: ' (glps.application_id = 200 AND '||
1610: ' xah.ledger_id = xte.ledger_id)) '||
1611: ' AND dr.event_id = xah.event_id '||

Line 1659: ' xla_ae_headers xah '||

1655: ' AND NOT EXISTS '||
1656: ' (SELECT 1 '||
1657: ' FROM gl_period_statuses glps, '||
1658: ' xla_transaction_entities_upg xte, '||
1659: ' xla_ae_headers xah '||
1660: ' WHERE (glps.application_id = 101 OR '||
1661: ' (glps.application_id = 200 AND '||
1662: ' xah.ledger_id = xte.ledger_id)) '||
1663: ' AND dr.event_id = xah.event_id '||

Line 1712: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

1708: l_check_process_flag VARCHAR2(1) := 'N';
1709: l_message VARCHAR2(4000);
1710: l_calling_sequence VARCHAR2(4000);
1711:
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;

Line 1713: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

1709: l_message VARCHAR2(4000);
1710: l_calling_sequence VARCHAR2(4000);
1711:
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;

Line 1714: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

1710: l_calling_sequence VARCHAR2(4000);
1711:
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;

Line 1715: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

1711:
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;

Line 1783: ' xla_ae_headers xah, '||

1779: ' glcc.enabled_flag, '||
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, '||

Line 1971: xla_ae_headers xah,

1967: xe.event_date gl_date,
1968: MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /*bug 13911650*/
1969: FROM xla_transaction_entities_upg xte,
1970: xla_events xe,
1971: xla_ae_headers xah,
1972: ap_system_parameters_all asp
1973: WHERE xte.entity_id = xe.entity_id
1974: AND xe.application_id = 200
1975: AND xte.entity_code = p_Source_Table

Line 2622: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

2618: undo_journals_details REFCURTYP;
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;

Line 2624: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

Line 2626: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE 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;
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;

Line 2627: TYPE balance_type_code_t IS TABLE OF XLA_AE_HEADERS.BALANCE_TYPE_CODE%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;
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;

Line 2928: ' xla_ae_headers xah, '||

2924: ' xal.accounted_cr, '||
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 '||

Line 2973: ' xla_ae_headers xah, '||

2969: ' xal.accounted_cr, '||
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 '||

Line 3555: xla_ae_headers xah,

3551:
3552: SELECT count(*)
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)

Line 3651: xla_ae_headers xah,

3647:
3648: SELECT count(*)
3649: INTO l_cnt_untrx_inv_evnts
3650: FROM xla_events xe,
3651: xla_ae_headers xah,
3652: xla_transaction_entities_upg xte,
3653: ap_invoices_all ai
3654: WHERE xe.application_id = 200
3655: AND xte.application_id = 200

Line 3684: xla_ae_headers xah,

3680:
3681: SELECT count(*)
3682: INTO l_cnt_untrx_pay_evnts
3683: FROM xla_events xe,
3684: xla_ae_headers xah,
3685: xla_transaction_entities_upg xte,
3686: ap_invoice_payments_all aip
3687: WHERE xe.application_id = 200
3688: AND xte.application_id = 200

Line 3752: FROM xla_ae_headers xah,

3748: AND aid.line_type_lookup_code = 'PREPAY'
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

Line 5413: , xla_ae_headers xah

5409: , nvl(xe.budgetary_control_flag, 'N') budgetary_control_flag /*Bug 12975723*/
5410: , MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /* bug 13911650*/
5411: FROM xla_transaction_entities_upg xte
5412: , xla_events xe
5413: , xla_ae_headers xah
5414: , ap_system_parameters_all asp
5415: WHERE xte.entity_id = xe.entity_id
5416: AND xe.application_id = 200
5417: AND xte.entity_code = 'AP_INVOICES'

Line 6082: xla_ae_headers xah

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
6086: AND xah.ae_header_id = xal.ae_header_id

Line 6111: xla_ae_headers xah

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
6115: AND xah.ae_header_id = xal.ae_header_id