SQL query to extract all the expenses submitted for a particular BU in oracle cloud HCM
This Sql query helps in extracting all the Expenses submitted for a particular BU in oracle cloud HCM. This helps in reviewing the total expenses paid for a particular BU. This query includes columns like employee name, employee number, expense report number, expense currency, expense amount etc.
Read MoreSQL query to extract all the open AR invoices for a particular BU in oracle cloud ERP
This query helps in extracting all the open AR invoices for a particular BU in oracle cloud ERP. This is extremely helpful in sending the extract to dunning softwares. SELECT apsa.TRX_NUMBER TRANSACTION_NUMBER , hou.NAME BU_NAME, CST.ACCOUNT_NUMBER CUSTOMER_NUMBER , hp.PARTY_NAME CUSTOMER_NAME , apsa.CLASS TRANSACTION_CLASS , rctta.NAME TRANSACTION_TYPE , rctta.DESCRIPTION TRANSACTION_TYPE_DESC, apsa.INVOICE_CURRENCY_CODE TRX_CURRENCY , apsa.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, apsa.AMOUNT_DUE_ORIGINAL […]
Read More