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_TRANSACTION_ENTITIES_UPG

Line 878: FROM xla_transaction_entities_upg xte

874: l_event_source_info.entity_type_code,
875: l_event_source_info.source_id_int_1,
876: l_event_source_info.transaction_number,
877: l_event_source_info.application_id
878: FROM xla_transaction_entities_upg xte
879: WHERE xte.application_id = 200
880: AND xte.entity_id = l_entity_id;
881:
882: EXCEPTION

Line 1013: FROM xla_transaction_entities_upg xte

1009: INTO l_dummy
1010: FROM dual
1011: WHERE EXISTS
1012: (SELECT 1
1013: FROM xla_transaction_entities_upg xte
1014: WHERE xte.application_id = 200
1015: AND xte.entity_id = l_entity_id);
1016:
1017: EXCEPTION

Line 1236: ' xla_transaction_entities_upg xte, '||

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 '||
1239: ' WHERE xe.application_id = 200 '||
1240: ' AND xah.application_id =200 '||

Line 1372: ' xla_transaction_entities_upg xte, '||

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 '||
1375: ' WHERE xe.application_id = 200 '||
1376: ' AND xah.application_id =200 '||

Line 1529: ' xla_transaction_entities_upg xte '||

1525: ' dr.calculated_undo_period) = '||
1526: ' (SELECT dr.proposed_undo_date, glps.period_name '||
1527: ' FROM xla_events xe, '||
1528: ' gl_period_statuses glps, '||
1529: ' xla_transaction_entities_upg xte '||
1530: ' WHERE xe.application_id = 200 '||
1531: ' AND glps.application_id = 200 '||
1532: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1533: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1552: ' xla_transaction_entities_upg xte, '||

1548: ' AND dr.calculated_undo_date IS NULL '||
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)) '||

Line 1583: ' xla_transaction_entities_upg xte '||

1579: ' dr.calculated_undo_period) = '||
1580: ' (SELECT xe.event_date, glps.period_name '||
1581: ' FROM xla_events xe, '||
1582: ' gl_period_statuses glps, '||
1583: ' xla_transaction_entities_upg xte '||
1584: ' WHERE xe.application_id = 200 '||
1585: ' AND glps.application_id = 200 '||
1586: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1587: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1606: ' xla_transaction_entities_upg xte, '||

1602: ' AND dr.calculated_undo_date IS NULL '||
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)) '||

Line 1635: ' xla_transaction_entities_upg xte '||

1631: ' dr.calculated_undo_period) = '||
1632: ' (SELECT trunc(sysdate), glps.period_name '||
1633: ' FROM xla_events xe, '||
1634: ' gl_period_statuses glps, '||
1635: ' xla_transaction_entities_upg xte '||
1636: ' WHERE xe.application_id = 200 '||
1637: ' AND glps.application_id = 200 '||
1638: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1639: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1658: ' xla_transaction_entities_upg xte, '||

1654: ' AND dr.calculated_undo_date IS NULL '||
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)) '||

Line 1786: ' xla_transaction_entities_upg xte, '||

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 '||
1789: ' WHERE xe.application_id = 200 '||
1790: ' AND xah.application_id = 200 '||

Line 1969: FROM xla_transaction_entities_upg xte,

1965: security_id_int_1 cur_org_id,
1966: decode(xte.entity_code, 'AP_PAYMENTS', 'CHECKS', 'AP_INVOICES', 'INVOICES') check_or_invoice,
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

Line 2754: ' FROM xla_transaction_entities_upg xte, '||

2750: ' xte.security_id_int_1, '||
2751: ' dr.calculated_undo_date, '||
2752: ' dr.calculated_undo_period, '||
2753: ' xe.budgetary_control_flag '|| --Bug 10072990
2754: ' FROM xla_transaction_entities_upg xte, '||
2755: ' xla_events xe, '||
2756: l_driver_table||' dr '||
2757: ' WHERE xte.application_id = 200 '||
2758: ' AND xe.application_id = 200 '||

Line 2930: ' xla_transaction_entities_upg xte, '||

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 '||
2934: ' AND xah.application_id = 200 '||

Line 2975: ' xla_transaction_entities_upg xte, '||

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 '||
2979: ' AND xah.application_id = 200 '||

Line 3090: ' FROM xla_transaction_entities_upg xte, '||

3086: ' ''UNEXPECTED_EXCEPTION'', ''Unexpected Exception Occurred'', '||
3087: ' ''SUCCESS'', ''Success'', '||
3088: ' ''Relevant Error Not Found '' '||
3089: ' ) '||
3090: ' FROM xla_transaction_entities_upg xte, '||
3091: ' xla_events xe, '||
3092: l_driver_table||' dr '||
3093: ' WHERE xte.application_id = 200 '||
3094: ' AND xe.application_id = 200 '||

Line 3271: xla_transaction_entities_upg XTE

3267: XE.Event_Status_Code,
3268: XTE.Entity_Code,
3269: XTE.Source_ID_Int_1
3270: FROM xla_events XE,
3271: xla_transaction_entities_upg XTE
3272: WHERE XE.application_id = 200
3273: AND XTE.application_id = 200
3274: AND XE.entity_id = XTE.entity_id
3275: AND XE.event_id = p_event_id;

Line 3556: xla_transaction_entities_upg xte,

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)
3560: AND aip.set_of_books_id = xte.ledger_id

Line 3589: xla_transaction_entities_upg xte,

3585:
3586: SELECT count(*)
3587: INTO l_cnt_unacc_inv_evnts
3588: FROM xla_events xe,
3589: xla_transaction_entities_upg xte,
3590: ap_invoices_all ai
3591: WHERE xe.application_id = 200
3592: AND xte.application_id = 200
3593: AND xe.entity_id = xte.entity_id

Line 3619: xla_transaction_entities_upg xte,

3615:
3616: SELECT count(*)
3617: INTO l_cnt_unacc_pay_evnts
3618: FROM xla_events xe,
3619: xla_transaction_entities_upg xte,
3620: ap_invoice_payments_all aip
3621: WHERE xe.application_id = 200
3622: AND xte.application_id = 200
3623: AND xte.entity_code = 'AP_PAYMENTS'

Line 3652: xla_transaction_entities_upg xte,

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
3656: AND xah.application_id = 200

Line 3685: xla_transaction_entities_upg xte,

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
3689: AND xte.entity_code = 'AP_PAYMENTS'

Line 3935: FROM xla_transaction_entities_upg xte,

3931:
3932: l_debug_info := 'before fetching the check_id';
3933: SELECT xte.source_id_int_1
3934: INTO l_check_id
3935: FROM xla_transaction_entities_upg xte,
3936: xla_events xe
3937: WHERE xe.application_id = 200
3938: AND xte.application_id = 200
3939: AND xe.entity_id = xte.entity_id

Line 4313: FROM xla_transaction_entities_upg xte

4309: l_event_source_info.entity_type_code,
4310: l_event_source_info.source_id_int_1,
4311: l_event_source_info.transaction_number,
4312: l_event_source_info.application_id
4313: FROM xla_transaction_entities_upg xte
4314: WHERE NVL(xte.source_id_int_1, -99) = p_source_id
4315: AND xte.entity_code = p_source_type
4316: AND xte.application_id = 200;
4317:

Line 5411: FROM xla_transaction_entities_upg xte

5407: , security_id_int_1 cur_org_id
5408: , xe.event_date gl_date
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