DBA Data[Home] [Help]

APPS.FARX_CP dependencies on FA_ASSET_HISTORY

Line 66: FA_ASSET_HISTORY FAHIST,

62: FABKS.COST)*(SUM(FADH.UNITS_ASSIGNED)/FAHIST.UNITS),h_precision)
63: FROM GL_CODE_COMBINATIONS DHCC,
64: FA_DISTRIBUTION_HISTORY FADH,
65: FA_CATEGORY_BOOKS FACB,
66: FA_ASSET_HISTORY FAHIST,
67: FA_ADDITIONS FADD,
68: FA_BOOKS FABKS,
69: FA_TRANSACTION_HEADERS FATRANS
70: WHERE FATRANS.TRANSACTION_TYPE_CODE = 'ADDITION'

Line 76: FROM FA_ASSET_HISTORY AH

72: AND FATRANS.DATE_EFFECTIVE BETWEEN
73: h_period1_pod
74: AND nvl(h_period2_pcd, sysdate) -- fix for bug 2865813
75: AND EXISTS (SELECT NULL
76: FROM FA_ASSET_HISTORY AH
77: WHERE AH.ASSET_ID = FATRANS.ASSET_ID
78: AND AH.ASSET_TYPE = 'CIP')
79: AND FATRANS.ASSET_ID = FADH.ASSET_ID
80: AND FATRANS.BOOK_TYPE_CODE = FADH.BOOK_TYPE_CODE