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_TRANSFER_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;

146: g_batch_name VARCHAR2(50);
147: g_accounting_batch_id PLS_INTEGER;
148: g_entity_id NUMBER; -- 8761772
149: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;

Line 151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;

147: g_accounting_batch_id PLS_INTEGER;
148: g_entity_id NUMBER; -- 8761772
149: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;

Line 152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;

148: g_entity_id NUMBER; -- 8761772
149: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;

Line 153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;

149: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
157: g_caller VARCHAR2(80);

Line 154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;

150: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
157: g_caller VARCHAR2(80);
158:

Line 155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;

151: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
157: g_caller VARCHAR2(80);
158:
159:

Line 156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;

152: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
153: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
154: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
155: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
156: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
157: g_caller VARCHAR2(80);
158:
159:
160: -- Batch level global variables

Line 1932: ,xla_transaction_entities xte

1928: 'SELECT DISTINCT aeh.period_name
1929: ,aeh.ledger_id
1930: FROM xla_ae_headers aeh
1931: ,gl_period_statuses gps
1932: ,xla_transaction_entities xte
1933: ,xla_event_types_b xet
1934: ,xla_event_class_attrs xec
1935: ,xla_ledger_relationships_v xlr
1936: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 2011: ,xla_transaction_entities xte

2007: l_statement := '
2008: SELECT DISTINCT gps.period_year
2009: ,gbv.budget_name
2010: FROM xla_ae_headers aeh
2011: ,xla_transaction_entities xte
2012: ,xla_event_types_b xet
2013: ,xla_event_class_attrs xec
2014: ,gl_period_statuses gps
2015: ,gl_budget_period_ranges gbp

Line 2088: ,xla_transaction_entities xte

2084: ' SELECT DISTINCT aeh.ledger_id
2085: ,gll.latest_encumbrance_year
2086: FROM xla_ae_headers aeh
2087: ,gl_period_statuses gps
2088: ,xla_transaction_entities xte
2089: ,xla_event_types_b xet
2090: ,xla_event_class_attrs xec
2091: ,gl_ledgers gll
2092: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 2356: ,xla_transaction_entities xte

2352: ,aeh.gl_transfer_date
2353: ,aeh.gl_transfer_status_code
2354: ,aeh.group_id
2355: FROM xla_ae_headers aeh
2356: ,xla_transaction_entities xte
2357: --,xla_event_types_b xet
2358: --,xla_event_class_attrs xeca
2359: --,xla_event_classes_b xec -- commented for bug12542507 and made it as IN clause
2360: WHERE xte.entity_id = aeh.entity_id