DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_ASSET_INVOICES

Line 1423: from fa_asset_invoices_mrc_v ai,

1419: px_inv_rec.Task_Id ,
1420: px_inv_rec.Depreciate_In_Group_Flag ,
1421: px_inv_rec.Material_Indicator_Flag ,
1422: px_inv_rec.prior_source_line_id
1423: from fa_asset_invoices_mrc_v ai,
1424: fa_invoice_transactions it
1425: where ai.source_line_id = px_inv_rec.source_line_id
1426: and it.invoice_transaction_id = ai.invoice_transaction_id_in
1427: and it.transaction_type = 'RETIREMENT';

Line 1526: from fa_asset_invoices ai,

1522: px_inv_rec.Source_Line_Id ,
1523: px_inv_rec.Depreciate_In_Group_Flag ,
1524: px_inv_rec.Material_Indicator_Flag ,
1525: px_inv_rec.Prior_Source_Line_ID
1526: from fa_asset_invoices ai,
1527: fa_invoice_transactions it
1528: where ai.source_line_id = px_inv_rec.source_line_id
1529: and it.invoice_transaction_id = ai.invoice_transaction_id_in
1530: and it.transaction_type = 'RETIREMENT';

Line 1630: from fa_asset_invoices_mrc_v

1626: px_inv_rec.Task_Id ,
1627: px_inv_rec.Depreciate_In_Group_Flag ,
1628: px_inv_rec.Material_Indicator_Flag ,
1629: px_inv_rec.prior_source_line_id
1630: from fa_asset_invoices_mrc_v
1631: where source_line_id = px_inv_rec.source_line_id
1632: and date_ineffective is null;
1633:
1634: else

Line 1731: from fa_asset_invoices

1727: px_inv_rec.Source_Line_Id ,
1728: px_inv_rec.Depreciate_In_Group_Flag ,
1729: px_inv_rec.Material_Indicator_Flag ,
1730: px_inv_rec.Prior_Source_Line_ID
1731: from fa_asset_invoices
1732: where source_line_id = px_inv_rec.source_line_id
1733: and date_ineffective is null;
1734:
1735: end if;