DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 1312: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev

1308: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.get_event_list';
1309:
1310: Cursor get_events IS
1311: select ev.event_id, en.entity_code
1312: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1313: where th.book_type_code = g_book
1314: and th.asset_id = g_asset_id
1315: and en.application_id = l_appid
1316: and en.ledger_id = g_sob_id

Line 1323: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev

1319: and ev.application_id = l_appid
1320: and ev.entity_id = en.entity_id
1321: union
1322: select ev.event_id, en.entity_code
1323: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1324: where th.book_type_code = g_book
1325: and th.asset_id = g_asset_id
1326: and en.application_id = l_appid
1327: and en.ledger_id = g_sob_id

Line 1334: from xla_transaction_entities en, xla_events ev, fa_book_controls bc

1330: and ev.application_id = l_appid
1331: and ev.entity_id = en.entity_id
1332: union
1333: select ev.event_id, en.entity_code
1334: from xla_transaction_entities en, xla_events ev, fa_book_controls bc
1335: where bc.book_type_code = g_book
1336: and en.application_id = l_appid
1337: and en.ledger_id = g_sob_id
1338: and en.entity_code = 'DEPRECIATION'

Line 1411: l_options_tbl(l_idx).l_tbl := 'XLA_TRANSACTION_ENTITIES';

1407: l_options_tbl(l_idx).l_num_cols := 2;
1408: l_options_tbl(l_idx).l_add_clause := ' from XLA_EVENTS where application_id = '||l_appid||' and event_id '||l_event_list;
1409: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
1410: l_idx:= l_idx+ 1;
1411: l_options_tbl(l_idx).l_tbl := 'XLA_TRANSACTION_ENTITIES';
1412: l_options_tbl(l_idx).l_schema := get_schema('XLA');
1413: l_options_tbl(l_idx).l_gen_select := 'Y';
1414: l_options_tbl(l_idx).l_col_order := 'ENTITY_CODE,VALUATION_METHOD';
1415: l_options_tbl(l_idx).l_lcs := 'ENTITY_ID,LEDGER_ID';

Line 1419: l_options_tbl(l_idx).l_add_clause := ' from XLA_TRANSACTION_ENTITIES where application_id = '||l_appid

1415: l_options_tbl(l_idx).l_lcs := 'ENTITY_ID,LEDGER_ID';
1416: l_options_tbl(l_idx).l_leading_cols := fafsc('ENTITY_ID')||fafsc('LEDGER_ID');
1417: l_options_tbl(l_idx).l_lc_header := fparse_header('ENTITY_ID')||fparse_header('LEDGER_ID');
1418: l_options_tbl(l_idx).l_num_cols := 2;
1419: l_options_tbl(l_idx).l_add_clause := ' from XLA_TRANSACTION_ENTITIES where application_id = '||l_appid
1420: ||' and entity_id in (select entity_id from xla_events where event_id '||l_event_list||')';
1421: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
1422: l_idx:= l_idx+ 1;
1423: l_options_tbl(l_idx).l_tbl := 'XLA_AE_HEADERS';