DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 478: FA_DISTRIBUTION_HISTORY DH,

474: FA_ASSET_HISTORY AH,
475: FA_TRANSACTION_HEADERS TH,
476: FA_TRANSACTION_HEADERS TH_RT,
477: FA_BOOKS BOOKS,
478: FA_DISTRIBUTION_HISTORY DH,
479: FA_CATEGORY_BOOKS CB
480: WHERE
481: CB.BOOK_TYPE_CODE = book AND
482: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 1594: fa_distribution_history dh

1590: CURSOR c_location (c_asset_id NUMBER, c_to_date DATE, c_book_type_code VARCHAR2) IS
1591: select
1592: distinct dh.location_id, dh.code_combination_id
1593: from
1594: fa_distribution_history dh
1595: where
1596: dh.asset_id = c_asset_id and
1597: dh.book_type_code = c_book_type_code and
1598: dh.date_effective <= c_to_date and