APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on FA_CATEGORIES_B_KFV

Line 389: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb

385: SELECT category
386: INTO lv_before(1)
387: FROM (
388: SELECT fcb.concatenated_segments category
389: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb
390: WHERE (fahv.key = v_row.transaction_header_id)
391: AND fahv.category_id = fcb.category_id
392: ORDER BY fahv.transaction_header_id_in)
393: WHERE ROWNUM = 1;

Line 399: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb

395: SELECT category
396: INTO lv_after(1)
397: FROM (
398: SELECT fcb.concatenated_segments category
399: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb
400: WHERE (fahv.key = v_row.transaction_header_id)
401: AND fahv.category_id = fcb.category_id
402: ORDER BY fahv.transaction_header_id_in DESC)
403: WHERE ROWNUM = 1;