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 490: ,XLA_TRANSACTION_ENTITIES ENT

486: ,xlo1.meaning PRINT_STATUS ';
487:
488: C_EVENTS_FROM_QUERY :=
489: ' FROM XLA_EVENTS XLE
490: ,XLA_TRANSACTION_ENTITIES ENT
491: ,XLA_SUBLEDGERS XLS
492: ,FND_USER FNU
493: ,GL_PERIOD_STATUSES GPS
494: ,GL_LEDGERS GLD

Line 584: ,XLA_TRANSACTION_ENTITIES ENT

580:
581: C_HEADERS_FROM_QUERY :=
582: ' FROM XLA_AE_HEADERS AEH
583: ,XLA_EVENTS XLE
584: ,XLA_TRANSACTION_ENTITIES ENT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU
587: ,GL_PERIOD_STATUSES GPS
588: ,GL_LEDGERS GLD

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

653: ,p_event_filter IN VARCHAR2
654: ,p_header_filter IN VARCHAR2) IS
655:
656: C_EVENTS_HEADERS_QUERY VARCHAR2(8000) :=
657: 'SELECT /*+ index(ent XLA_TRANSACTION_ENTITIES_U1) */ DISTINCT
658: xle.application_id APPLICATION_ID
659: ,xcl.entity_code ENTITY_CODE
660: ,xcl.event_class_code EVENT_CLASS_CODE
661: ,gjct.reporting_view_name REPORTING_VIEW_NAME

Line 665: ,xla_transaction_entities ent

661: ,gjct.reporting_view_name REPORTING_VIEW_NAME
662: FROM xla_events xle
663: ,xla_event_types_b xcl
664: ,xla_event_class_attrs gjct
665: ,xla_transaction_entities ent
666: ,xla_ledger_options xlo
667: WHERE ent.entity_id = xle.entity_id
668: AND ent.application_id = xle.application_id
669: AND ent.ledger_id = xlo.ledger_id

Line 691: ,xla_transaction_entities ent

687: ,gjct.reporting_view_name REPORTING_VIEW_NAME
688: FROM xla_ae_headers aeh
689: ,xla_event_types_b xcl
690: ,xla_event_class_attrs gjct
691: ,xla_transaction_entities ent
692: WHERE xcl.application_id = aeh.application_id
693: AND xcl.event_type_code = aeh.event_type_code
694: AND gjct.application_id = xcl.application_id
695: AND gjct.entity_code = xcl.entity_code

Line 1411: ,xla_transaction_entities xte

1407: INTO l_unprocessed
1408: FROM dual
1409: WHERE EXISTS(select 1
1410: FROM xla_events xle
1411: ,xla_transaction_entities xte
1412: ,gl_ledger_relationships glr1
1413: ,gl_ledger_relationships glr2
1414: ,xla_ledger_options xlo
1415: WHERE xle.entity_id = xte.entity_id

Line 1440: ,xla_transaction_entities xte

1436: --IF l_unprocessed = 0 THEN
1437: SELECT count(*)
1438: INTO l_unprocessed
1439: FROM xla_ae_headers aeh
1440: ,xla_transaction_entities xte
1441: ,gl_ledger_relationships glr1
1442: ,gl_ledger_relationships glr2
1443: WHERE aeh.ledger_id = glr2.target_ledger_id
1444: AND glr2.source_ledger_id = glr1.source_ledger_id

Line 1470: ,xla_transaction_entities xte

1466: INTO l_unprocessed
1467: FROM dual
1468: WHERE EXISTS(select 1
1469: FROM xla_events xle
1470: ,xla_transaction_entities xte
1471: ,gl_ledger_relationships glr1
1472: ,gl_ledger_relationships glr2
1473: ,xla_ledger_options xlo
1474: WHERE xle.entity_id = xte.entity_id

Line 1504: ,xla_transaction_entities xte

1500: --IF l_unprocessed = 0 THEN
1501: SELECT count(*)
1502: INTO l_unprocessed
1503: FROM xla_ae_headers aeh
1504: ,xla_transaction_entities xte
1505: ,gl_ledger_relationships glr1
1506: ,gl_ledger_relationships glr2
1507: WHERE aeh.ledger_id = glr2.target_ledger_id
1508: AND glr2.source_ledger_id = glr1.source_ledger_id