Doyen System Pvt. Ltd.
Wednesday, 23 August 2017
SQL to Find Employee – Supervisor Hierarchy details
›
Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the iss...
4 comments:
Thursday, 13 July 2017
Query for finding MTD/YTD/ITD Cost/Revenue and Fee Details for a Project in PA Module
›
WITH PARAMETER AS (SELECT :PERIOD_NAME AS PERIOD_NAME FROM DUAL) SELECT distinct prj.project_id,prj.segment1, (SELECT ROUND(SUM(tot_b...
Monday, 19 June 2017
GL Transactions for Payments
›
SELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHA...
GL Transactions for AR
›
SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl...
‹
›
Home
View web version
