DBA Data[Home] [Help]

APPS.FA_MODIFY_DISTRIBUTIONS_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 296: FROM fa_distribution_history DH

292: x_units NUMBER;
293:
294: CURSOR DH_C IS
295: SELECT DH.rowid row_id, DH.*
296: FROM fa_distribution_history DH
297: WHERE DH.asset_id = X_asset_id
298: AND DH.distribution_id = NVL(X_dist_id, DH.distribution_id)
299: AND DH.location_id = NVL(X_location_id, DH.location_id)
300: AND DH.code_combination_id = NVL(X_ccid, DH.code_combination_id)