APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_CATEGORIES_B

Line 331: FROM fa_asset_history_v fahv, fa_categories_b fcb

327: SELECT units
328: INTO lv_before(1)
329: FROM (
330: SELECT fahv.units units
331: FROM fa_asset_history_v fahv, fa_categories_b fcb
332: WHERE (fahv.key = v_row.transaction_header_id)
333: AND fahv.category_id = fcb.category_id
334: ORDER BY fahv.transaction_header_id_in)
335: WHERE ROWNUM = 1;

Line 341: FROM fa_asset_history_v fahv, fa_categories_b fcb

337: SELECT units
338: INTO lv_after(1)
339: FROM (
340: SELECT fahv.units units
341: FROM fa_asset_history_v fahv, fa_categories_b fcb
342: WHERE (fahv.key = v_row.transaction_header_id)
343: AND fahv.category_id = fcb.category_id
344: ORDER BY fahv.transaction_header_id_in DESC)
345: WHERE ROWNUM = 1;

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;