FA - Fixed Assets Archives - oracleappshelp.com

SQL Query to drill down from the Oracle apps R12 FA Assets mapping to GL

By oracleappsadminPosted on November 27, 2017Posted in FA - Fixed AssetsTagged drill down from FA to GL, FA Assets details mapped with GL tables, Oracle apps R12 FA Assets mapping to GL, Oralce Apps R12 Fixed Assets drill down details, XLA table mapping for FA assets details

The below query provides the drill down from the FA Assets mapping to GL with XLA Tables SELECT FTH.ASSET_ID, FAB.ASSET_NUMBER, FTH.TRANSACTION_TYPE_CODE, FTH.DATE_EFFECTIVE, FAB.ASSET_TYPE, GJH.JE_HEADER_ID, GJH.PERIOD_NAME, XE.EVENT_ID, GJH.NAME HEADER_NAME, GCC.SEGMENT1 BC, GCC.SEGMENT3 DEPT, GCC.SEGMENT4 ACCT FROM GL_JE_HEADERS GJH, GL.GL_JE_LINES GJL, GL.GL_CODE_COMBINATIONS GCC, GL.GL_PERIODS GLP, GL_IMPORT_REFERENCES IMP, XLA_AE_LINES XAL , XLA.XLA_AE_HEADERS XAH, XLA.XLA_EVENTS XE, XLA_TRANSACTION_ENTITIES XTE, FA_TRANSACTION_HEADERS […]

Query to fetch fixed asset invoices in oracle apps

By oracleappsadminPosted on November 21, 2017August 10, 2020Posted in FA - Fixed AssetsTagged Fixed assets details related to invoice, vendor and project specific details in R12

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 […]

Extract fixed asset and depreciation details in Oracle apps R12

By oracleappsadminPosted on November 21, 2017November 21, 2017Posted in FA - Fixed AssetsTagged depreciation details for an asset in R12, fixed asset and depreciation details in Oracle apps R12, fixed asset details in R12, oracle apps R12 Fixed Asset data retrieval

The below query provides the extract for the Fixed Asset information and related depreciation details SELECT ‘A’ RECORD_IDENTIFIER, FAB.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 EXPENSE_ACCOUNT, FAB.ASSET_ID ASSET_ID FROM APPS.FA_ADDITIONS_B FAB, APPS.FA_ADDITIONS_TL FAT, APPS.FA_BOOKS […]