DBA Data[Home] [Help]

APPS.FA_FAS860_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 80: FA_BOOK_CONTROLS BC

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 (+),

Line 173: FA_BOOK_CONTROLS BC,

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

Line 205: FA_BOOK_CONTROLS BC,

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

Line 225: FA_BOOK_CONTROLS BC,

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