Oracle Apps Fixed Asset R12 project mapping

Fixed assets details related to invoice, vendor and project specific details in R12

the below 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_ID FROM APPS.FA_ASSET_INVOICES FAI, (SELECT FAB.ASSET_TYPE ASSET_CLASS, FAB.ASSET_NUMBER ASSET, […]

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