76: FROM
77: FA_MASS_CHANGES MCH,
78: FA_METHODS FM,
79: FA_METHODS TM,
80: FA_BOOK_CONTROLS BC
81: --WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID
82: WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID1
83: AND FM.METHOD_CODE (+) = MCH.FROM_METHOD_CODE
84: AND NVL(FM.LIFE_IN_MONTHS (+),
169: 'PRODUCTION IN TAX'
170: INTO
171: TEMP
172: FROM
173: FA_BOOK_CONTROLS BC,
174: FA_BOOKS BK,
175: FA_METHODS ME
176: WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
177: AND BK.ASSET_ID = ASSET_ID
201: UNIT_OF_MEASURE
202: INTO
203: NEW_UOM
204: FROM
205: FA_BOOK_CONTROLS BC,
206: FA_BOOKS BK
207: WHERE BK.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK
208: AND BK.ASSET_ID = ASSET_ID
209: AND BK.DATE_INEFFECTIVE IS NULL
221: 'PRODUCTION IN CORP'
222: INTO
223: TEMP
224: FROM
225: FA_BOOK_CONTROLS BC,
226: FA_BOOKS BK,
227: FA_METHODS ME
228: WHERE BK.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK
229: AND BK.ASSET_ID = ASSET_ID