DBA Data[Home] [Help]

APPS.PA_FA_TIEBACK_PVT dependencies on FA_INVOICE_TRANSACTIONS

Line 25: fa_invoice_transactions fit,

21: CURSOR earliest_asset_period_cur(x_project_asset_id NUMBER) IS
22: SELECT fdp.period_name, MIN(fit.date_effective)
23: FROM fa_deprn_periods fdp,
24: fa_asset_invoices fai,
25: fa_invoice_transactions fit,
26: pa_project_asset_lines_all pal
27: WHERE fai.project_asset_line_id = pal.project_asset_line_id
28: AND pal.project_asset_id = x_project_asset_id
29: AND fai.invoice_transaction_id_in = fit.invoice_transaction_id

Line 59: fa_invoice_transactions fit

55: SELECT fdp.period_name,
56: SUM(payables_cost) payables_cost
57: FROM fa_deprn_periods fdp,
58: fa_asset_invoices fai,
59: fa_invoice_transactions fit
60: WHERE fai.project_asset_line_id = x_project_asset_line_id
61: AND fai.invoice_transaction_id_in = fit.invoice_transaction_id
62: AND fit.transaction_type = 'MASS ADDITION'
63: AND fit.book_type_code = fdp.book_type_code