Fixed assets details related to invoice

Query to fetch fixed asset invoices in oracle apps

The below given query provides the data  extract related to the  invoice,vendor, project related details of assets   SELECT DISTINCT’I’ RECORD_IDENTIFIER,B.ASSET,FAI.INVOICE_NUMBER APBILL,FAI.AP_DISTRIBUTION_LINE_NUMBER INVOICE_LINE,(SELECT  PV.VENDOR_NAME FROM APPS.PO_VENDORS PV WHERE PV.VENDOR_ID  = FAI.PO_VENDOR_ID ) SUPPLIER,(SELECT PPA.NAME FROM APPS.PA_PROJECTS_ALL PPA WHERE  PPA.PROJECT_ID=FAI.PROJECT_ID )PROJECT,FAI.FIXED_ASSETS_COST INVOICE_LINE_AMOUNT,B.ASSET_IDFROMAPPS.FA_ASSET_INVOICES FAI,(SELECTFAB.ASSET_TYPE ASSET_CLASS,FAB.ASSET_NUMBER ASSET,FAB.ASSET_NUMBER ASSET_NAME,FAT.DESCRIPTION ASSET_DESCRITPION,PAPF.FULL_NAME EMPLOYEE,FLK.CONCATENATED_SEGMENTS LOCATION,FB.BOOK_TYPE_CODE BOOK,FB.ORIGINAL_COST ASSET_COST,GSOB.CURRENCY_CODE CURRENCY_CODE,FDS.DEPRN_RESERVE ACCUMULATED_DEPRECIATION,FB.DATE_PLACED_IN_SERVICE,FDS.DEPRN_RUN_DATE LAST_POSTING_DATE,FAB.TAG_NUMBER ASSET_TAG,FAB.SERIAL_NUMBER SERIAL_NUMBER,GCCK.CONCATENATED_SEGMENTS […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.