DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on FA_ADDITIONS_B

Line 202: FROM fa_additions_b

198: g_asset_id := to_number(p_asset_number);
199:
200: SELECT asset_number
201: INTO g_asset_number
202: FROM fa_additions_b
203: where asset_id = g_asset_id;
204: else
205: g_asset_number := p_asset_number;
206: BEGIN

Line 209: FROM fa_additions_b

205: g_asset_number := p_asset_number;
206: BEGIN
207: SELECT asset_id
208: INTO l_asset_id
209: FROM fa_additions_b
210: WHERE asset_number = p_asset_number;
211:
212: g_asset_id := l_asset_id;
213:

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

448: and asset_id = g_asset_id
449: and book_type_code = g_book;
450:
451: l_idx:= l_idx+ 1;
452: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';
453: l_options_tbl(l_idx).l_gen_select := 'Y';
454: l_options_tbl(l_idx).l_col_order := 'ASSET_NUMBER,ASSET_TYPE,ASSET_CATEGORY_ID,CURRENT_UNITS';
455: l_idx:= l_idx+ 1;
456: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';