APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on FA_ASSET_HISTORY_V

Line 360: FROM fa_asset_history_v fahv, fa_categories_b fcb

356: SELECT units
357: INTO lv_before(1)
358: FROM (
359: SELECT fahv.units units
360: FROM fa_asset_history_v fahv, fa_categories_b fcb
361: WHERE (fahv.key = v_row.transaction_header_id)
362: AND fahv.category_id = fcb.category_id
363: ORDER BY fahv.transaction_header_id_in)
364: WHERE ROWNUM = 1;

Line 370: FROM fa_asset_history_v fahv, fa_categories_b fcb

366: SELECT units
367: INTO lv_after(1)
368: FROM (
369: SELECT fahv.units units
370: FROM fa_asset_history_v fahv, fa_categories_b fcb
371: WHERE (fahv.key = v_row.transaction_header_id)
372: AND fahv.category_id = fcb.category_id
373: ORDER BY fahv.transaction_header_id_in DESC)
374: WHERE ROWNUM = 1;

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;