Current Period Status of Application (oracle 11i)

Monday, November 10th, 2008 at 1:33 pm by Jiltin
Filed under: 11i Scripts 

/*
Description: This script current period status of application (oracle 11i)
Author: Jay Gopalakrishnan / Jiltin
Input: &&Chart_of_accounts_id,&&application_id
*/

Download the code

SELECT gls.name, gps.closing_status FROM
apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls
WHERE 1=1
AND gps.start_date <= SYSDATE
AND gps.end_date >= SYSDATE
AND gps.set_of_books_id = gls.set_of_books_id
AND gps.application_id=&&application_id
AND gls.chart_of_accounts_id=&&Chart_of_accounts_id
AND gls.name IN ( ‘OPER US’,‘OPER Australia’,‘OPER Japan’,‘OPER UK’, ‘OPER Hong Kong’,‘OPER Europe’,‘OPER China’ );

Tags: , , ,

Comments