eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FA_TIEBACK_PVT dependencies on FA_ASSET_INVOICES

Line 24: fa_asset_invoices fai,

20:
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

Line 58: fa_asset_invoices fai,

54: CURSOR asset_line_period_cur(x_project_asset_line_id NUMBER) IS
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'

Line 74: fa_asset_invoices fai,

70:
71: CURSOR fa_assets_cur(x_project_asset_id NUMBER) IS
72: SELECT fa.asset_id, fa.asset_number
73: FROM fa_additions fa,
74: fa_asset_invoices fai,
75: pa_project_asset_lines_all pal
76: WHERE fai.project_asset_line_id = pal.project_asset_line_id
77: AND pal.project_asset_id = x_project_asset_id
78: AND fai.asset_id = fa.asset_id