APPS.FA_ASSET_TRACE_PKG dependencies on FA_ADDITIONS

Line 46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;

42: g_sel_tbl FA_ASSET_TRACE_PVT.t_asset_tbl;
43: g_no_rec_tbl t_asset_tbl;
44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;

Line 47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;

43: g_no_rec_tbl t_asset_tbl;
44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;

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';

Line 456: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';

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';
457: l_options_tbl(l_idx).l_gen_select := 'Y';
458: l_idx:= l_idx+ 1;
459: l_options_tbl(l_idx).l_tbl := 'FA_TRANSACTION_HEADERS';
460: l_options_tbl(l_idx).l_gen_select := 'Y';