DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on FA_ADDITIONS_B

Line 182: FROM fa_additions_b

178: g_asset_id := to_number(p_asset_number);
179:
180: SELECT asset_number
181: INTO g_asset_number
182: FROM fa_additions_b
183: where asset_id = g_asset_id;
184: else
185: g_asset_number := p_asset_number;
186: BEGIN

Line 189: FROM fa_additions_b

185: g_asset_number := p_asset_number;
186: BEGIN
187: SELECT asset_id
188: INTO l_asset_id
189: FROM fa_additions_b
190: WHERE asset_number = p_asset_number;
191:
192: g_asset_id := l_asset_id;
193:

Line 432: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';

428: and asset_id = g_asset_id
429: and book_type_code = g_book;
430:
431: l_idx:= l_idx+ 1;
432: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';
433: l_options_tbl(l_idx).l_gen_select := 'Y';
434: l_options_tbl(l_idx).l_col_order := 'ASSET_NUMBER,ASSET_TYPE,ASSET_CATEGORY_ID,CURRENT_UNITS';
435: l_idx:= l_idx+ 1;
436: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';