WITH PARAMETER AS (SELECT :PERIOD_NAME AS PERIOD_NAME FROM DUAL) SELECT distinct prj.project_id,prj.segment1, (SELECT ROUND(SUM(tot_burdened_cost),2) FROM apps.pa_txn_accum WHERE project_id=prj.project_id AND gl_period =PARAMETER.PERIOD_NAME — and…
Read MoreSELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHAR (aca.check_date) invoice_date, …
Read MoreSELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl.line_number) ponum_inv_linenum, rcl.description line_desc, TO_CHAR (rcl.quantity_invoiced) requestor_qty_inv, TO_CHAR…
Read MoreSELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_customer_trx_all WHERE customer_trx_id = aaa.customer_trx_id) invoice_date, …
Read MoreSELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type, ent.transaction_number invoice_num, TO_CHAR (aia.invoice_date) invoice_date, TO_CHAR (pod.po_number) ponum_inv_linenum, …
Read MoreSELECT papf.employee_number employee_number , aps.vendor_name payee_name , ieba.bank_account_num bank_account_number ,…
Read MoreGL Wand needs no desktop installation and it is very user friendly for creating many financial reports. It is a very good reporting tool for Oracle E-Business suite. Pre-Requisites :…
Read MoreError Message : ORA -00980 Synonym Translation no longer Valid. Error Area : it is related Database (Table/view) not related to forms When it happens : Synonym is in inconsistent…
Read MoreInstallation Issue : ‘ Spawning C:OracleATSbindeploy.bat C:OracleATSinstalloats.ear’ and never completes for Long Time ( even for Days) When it Happen : While Installing OATS Software Action Needs to Taken…
Read MoreHow to Create a User for ORACLE Load Testing LogIn Clink on Start Button ? Oracle Application Testing Suite ?Administrator Login with Administrator User as shown below Note: Ensure DataBase…
Read More