Friday, June 28, 2024

Query To Get Quarterly Start And End Date In EBS R12

 HOW TO GET QUARTRLY START AND END DATE ?


SELECT ADD_MONTHS (TRUNC (param.start_date, 'Q'), 3 * (LEVEL - 1) ) AS qstart, ADD_MONTHS (TRUNC (param.start_date, 'Q'), 3 * (LEVEL)) - 1 AS qend FROM ( SELECT TO_DATE ('&start_date') AS start_date, TO_DATE ('&end_date') AS end_date FROM DUAL) param CONNECT BY ADD_MONTHS (TRUNC (param.start_date, 'Q'), 3 * (LEVEL)) - 1 <= param.end_date

No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...