DBA Data[Home] [Help]

APPS.XLA_MULTIPERIOD_ACCOUNTING_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 765: , xla_transaction_entities xte

761: , xla_ae_headers xah2
762: , xla_subledgers xs
763: , xla_event_types_b xet
764: , xla_event_class_attrs xec
765: , xla_transaction_entities xte
766: WHERE xah.application_id = :1
767: and xah.accounting_date <= :2
768: and xah.accounting_entry_status_code IN (''I'', DECODE(:3, ''Y'', ''I'', ''N''))
769: AND xah.application_id = xah2.application_id

Line 1025: SELECT /*+ cardinality(H,1) INDEX(t xla_transaction_entities_u1) */ DISTINCT --bug9174950

1021: ,ledger_id
1022: ,entity_id
1023: ,entity_code
1024: ,event_id)
1025: SELECT /*+ cardinality(H,1) INDEX(t xla_transaction_entities_u1) */ DISTINCT --bug9174950
1026: g_application_id
1027: ,g_ledger_id
1028: ,h.entity_id
1029: ,t.entity_code

Line 1032: xla_transaction_entities t

1028: ,h.entity_id
1029: ,t.entity_code
1030: ,h.event_id
1031: FROM xla_ae_headers_gt h,
1032: xla_transaction_entities t
1033: WHERE h.entity_id = t.entity_id
1034: AND h.ledger_id = t.ledger_id
1035: AND t.application_id = g_application_id
1036: AND t.ledger_id = g_ledger_id;