APPS.CSE_ASSET_WIP_PKG dependencies on CSI_I_ASSETS

Line 61: FROM csi_i_assets cia,

57: fdh.units_assigned,
58: cia.update_status,
59: fdh.code_combination_id,
60: fdh.assigned_to
61: FROM csi_i_assets cia,
62: fa_distribution_history fdh
63: WHERE instance_id = c_instance_id
64: AND update_status = 'IN_SERVICE'
65: AND asset_quantity > 0