DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on FA_TRANSACTION_HEADERS

Line 80: ,fa_transaction_headers fth

76: AND fav.asset_type = 'CAPITALIZED'
77: AND fav.asset_id IN
78: (SELECT DISTINCT fdh.asset_id
79: FROM fa_distribution_history fdh
80: ,fa_transaction_headers fth
81: WHERE fdh.asset_id = fth.asset_id
82: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
83: AND EXISTS
84: (SELECT fdp.period_close_date

Line 128: ,fa_transaction_headers fth

124: AND fav.asset_type = 'CAPITALIZED'
125: AND fav.asset_id IN
126: (SELECT DISTINCT fdh.asset_id
127: FROM fa_distribution_history fdh
128: ,fa_transaction_headers fth
129: WHERE fdh.asset_id = fth.asset_id
130: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
131: AND EXISTS
132: (SELECT fdp.period_close_date

Line 176: ,fa_transaction_headers fth

172: AND fav.asset_type = 'CAPITALIZED'
173: AND fav.asset_id IN
174: (SELECT DISTINCT fdh.asset_id
175: FROM fa_distribution_history fdh
176: ,fa_transaction_headers fth
177: WHERE fdh.asset_id = fth.asset_id
178: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
179: AND EXISTS
180: (SELECT fdp.period_close_date