778: DH.CODE_COMBINATION_ID,
779: DH.UNITS_ASSIGNED
780: FROM
781: FA_DISTRIBUTION_HISTORY DH,
782: FA_TRANSACTION_HEADERS TH
783: WHERE
784: TH.TRANSACTION_HEADER_ID = X_adj.selection_thid AND
785: (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR
786: TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_OUT)