DBA Data[Home] [Help]

APPS.FA_SORP_UPG_PKG dependencies on FA_TRANSACTION_HEADERS

Line 141: fa_transaction_headers th,

137: det.distribution_id
138: from
139: fa_itf_impairments itf,
140: fa_impairments imp,
141: fa_transaction_headers th,
142: fa_adjustments adj,
143: fa_deprn_detail det
144: where itf.impairment_id = imp.impairment_id
145: and itf.impairment_id = th.mass_transaction_id

Line 170: fa_transaction_headers th,

166: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount
167: from
168: fa_itf_impairments itf,
169: fa_impairments imp,
170: fa_transaction_headers th,
171: fa_adjustments adj,
172: fa_deprn_summary su
173: where itf.impairment_id = imp.impairment_id
174: and itf.impairment_id = th.mass_transaction_id

Line 255: fa_transaction_headers th,

251: det.distribution_id
252: from
253: FA_MC_ITF_IMPAIRMENTS itf,
254: FA_MC_IMPAIRMENTS imp,
255: fa_transaction_headers th,
256: fa_adjustments adj,
257: FA_MC_DEPRN_DETAIL det
258: where itf.impairment_id = imp.impairment_id
259: and itf.impairment_id = th.mass_transaction_id

Line 285: fa_transaction_headers th,

281: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount
282: from
283: FA_MC_ITF_IMPAIRMENTS itf,
284: FA_MC_IMPAIRMENTS imp,
285: fa_transaction_headers th,
286: fa_adjustments adj,
287: FA_MC_DEPRN_SUMMARY su
288: where itf.impairment_id = imp.impairment_id
289: and itf.impairment_id = th.mass_transaction_id