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.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 496: ,XLA_TRANSACTION_ENTITIES ENT

492: ,xlo1.meaning PRINT_STATUS ';
493:
494: C_EVENTS_FROM_QUERY :=
495: ' FROM XLA_EVENTS XLE
496: ,XLA_TRANSACTION_ENTITIES ENT
497: ,XLA_SUBLEDGERS XLS
498: ,FND_USER FNU
499: ,GL_PERIOD_STATUSES GPS
500: ,GL_LEDGERS GLD

Line 591: ,XLA_TRANSACTION_ENTITIES ENT

587:
588: C_HEADERS_FROM_QUERY :=
589: ' FROM XLA_AE_HEADERS AEH
590: ,XLA_EVENTS XLE
591: ,XLA_TRANSACTION_ENTITIES ENT
592: ,XLA_SUBLEDGERS XLS
593: ,FND_USER FNU
594: ,GL_PERIOD_STATUSES GPS
595: ,GL_LEDGERS GLD

Line 664: 'SELECT /+ index(ent XLA_TRANSACTION_ENTITIES_U1) / DISTINCT

660: ,p_event_filter IN VARCHAR2
661: ,p_header_filter IN VARCHAR2) IS
662:
663: C_EVENTS_HEADERS_QUERY VARCHAR2(8000) :=
664: 'SELECT /*+ index(ent XLA_TRANSACTION_ENTITIES_U1) */ DISTINCT
665: xle.application_id APPLICATION_ID
666: ,xcl.entity_code ENTITY_CODE
667: ,xcl.event_class_code EVENT_CLASS_CODE
668: ,gjct.reporting_view_name REPORTING_VIEW_NAME

Line 672: ,xla_transaction_entities ent

668: ,gjct.reporting_view_name REPORTING_VIEW_NAME
669: FROM xla_events xle
670: ,xla_event_types_b xcl
671: ,xla_event_class_attrs gjct
672: ,xla_transaction_entities ent
673: ,xla_ledger_options xlo
674: WHERE ent.entity_id = xle.entity_id
675: AND ent.application_id = xle.application_id
676: AND ent.ledger_id = xlo.ledger_id

Line 698: ,xla_transaction_entities ent

694: ,gjct.reporting_view_name REPORTING_VIEW_NAME
695: FROM xla_ae_headers aeh
696: ,xla_event_types_b xcl
697: ,xla_event_class_attrs gjct
698: ,xla_transaction_entities ent
699: WHERE xcl.application_id = aeh.application_id
700: AND xcl.event_type_code = aeh.event_type_code
701: AND gjct.application_id = xcl.application_id
702: AND gjct.entity_code = xcl.entity_code

Line 1462: ,xla_transaction_entities xte

1458: INTO l_unprocessed
1459: FROM dual
1460: WHERE EXISTS(select 1
1461: FROM xla_events xle
1462: ,xla_transaction_entities xte
1463: ,gl_ledger_relationships glr1
1464: ,gl_ledger_relationships glr2
1465: ,xla_ledger_options xlo
1466: WHERE xle.entity_id = xte.entity_id

Line 1491: ,xla_transaction_entities xte

1487: --IF l_unprocessed = 0 THEN
1488: SELECT count(*)
1489: INTO l_unprocessed
1490: FROM xla_ae_headers aeh
1491: ,xla_transaction_entities xte
1492: ,gl_ledger_relationships glr1
1493: ,gl_ledger_relationships glr2
1494: WHERE aeh.ledger_id = glr2.target_ledger_id
1495: AND glr2.source_ledger_id = glr1.source_ledger_id

Line 1521: ,xla_transaction_entities xte

1517: INTO l_unprocessed
1518: FROM dual
1519: WHERE EXISTS(select 1
1520: FROM xla_events xle
1521: ,xla_transaction_entities xte
1522: ,gl_ledger_relationships glr1
1523: ,gl_ledger_relationships glr2
1524: ,xla_ledger_options xlo
1525: WHERE xle.entity_id = xte.entity_id

Line 1555: ,xla_transaction_entities xte

1551: --IF l_unprocessed = 0 THEN
1552: SELECT count(*)
1553: INTO l_unprocessed
1554: FROM xla_ae_headers aeh
1555: ,xla_transaction_entities xte
1556: ,gl_ledger_relationships glr1
1557: ,gl_ledger_relationships glr2
1558: WHERE aeh.ledger_id = glr2.target_ledger_id
1559: AND glr2.source_ledger_id = glr1.source_ledger_id