APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_BOOKS

Line 334: ,FA_BOOKS FB

330: FROM AP_INVOICES_ALL
331: WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
332: FROM FA_ASSET_INVOICES FAI
333: ,FA_ADDITIONS_B FA
334: ,FA_BOOKS FB
335: WHERE FAI.ASSET_ID = FA.ASSET_ID
336: AND FA.ASSET_ID = FB.ASSET_ID
337: AND FA.ASSET_ID = p_asset_id_in
338: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)

Line 342: ,FA_BOOKS FB

338: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
339: AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
340: FROM FA_ASSET_INVOICES FAI
341: ,FA_ADDITIONS_B FA
342: ,FA_BOOKS FB
343: WHERE FAI.ASSET_ID = FA.ASSET_ID
344: AND FA.ASSET_ID = FB.ASSET_ID
345: AND FA.ASSET_ID = p_asset_id_in
346: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME);

Line 355: ,FA_BOOKS FB

351: WHEN OTHERS THEN
352: SELECT FB.DATE_PLACED_IN_SERVICE
353: INTO ld_date
354: FROM FA_ADDITIONS_B FA
355: ,FA_BOOKS FB
356: WHERE FA.ASSET_ID = FB.ASSET_ID
357: AND FA.ASSET_ID = p_asset_id_in
358: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME
359: AND FB.TRANSACTION_HEADER_ID_OUT IS NULL;

Line 457: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';

453:
454: THEN
455: fnd_file.put_line(fnd_file.log,'R-b4 lp statementss ');
456: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
457: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
458: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
459: LP_FA_RETIREMENTS := 'FA_RETIREMENTS_MRC_V';
460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';

Line 464: lp_fa_books := 'FA_BOOKS';

460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';
462: ELSE
463: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
464: lp_fa_books := 'FA_BOOKS';
465: lp_fa_adjustments := 'FA_ADJUSTMENTS';
466: lp_fa_retirements := 'FA_RETIREMENTS';
467: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
468: lp_fa_asset_invoices := 'FA_ASSET_INVOICES';