DBA Data[Home] [Help]

APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_ASSET_INVOICES

Line 229: FROM FA_ASSET_INVOICES FAI

225: SELECT INVOICE_DATE
226: INTO ld_date
227: FROM AP_INVOICES_ALL
228: WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
229: FROM FA_ASSET_INVOICES FAI
230: ,FA_ADDITIONS_B FA
231: ,FA_BOOKS FB
232: WHERE FAI.ASSET_ID = FA.ASSET_ID
233: AND FA.ASSET_ID = FB.ASSET_ID

Line 237: FROM FA_ASSET_INVOICES FAI

233: AND FA.ASSET_ID = FB.ASSET_ID
234: AND FA.ASSET_ID = p_asset_id_in
235: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
236: AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
237: FROM FA_ASSET_INVOICES FAI
238: ,FA_ADDITIONS_B FA
239: ,FA_BOOKS FB
240: WHERE FAI.ASSET_ID = FA.ASSET_ID
241: AND FA.ASSET_ID = FB.ASSET_ID