DBA Data[Home] [Help]

APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_CATEGORIES_B_KFV

Line 358: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb

354: SELECT category
355: INTO lv_before(1)
356: FROM (
357: SELECT fcb.concatenated_segments category
358: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb
359: WHERE (fahv.key = v_row.transaction_header_id)
360: AND fahv.category_id = fcb.category_id
361: ORDER BY fahv.transaction_header_id_in)
362: WHERE ROWNUM = 1;

Line 368: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb

364: SELECT category
365: INTO lv_after(1)
366: FROM (
367: SELECT fcb.concatenated_segments category
368: FROM fa_asset_history_v fahv, fa_categories_b_kfv fcb
369: WHERE (fahv.key = v_row.transaction_header_id)
370: AND fahv.category_id = fcb.category_id
371: ORDER BY fahv.transaction_header_id_in DESC)
372: WHERE ROWNUM = 1;