Current Period Status of Application (oracle 11i)

Posted by Jiltin     Tags: , , , 10 November, 2008    596 views    (0) Comment

/* Description: This script current period status of application (oracle 11i) Author: Jay Gopal / 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 Read Full Article (Click here)...

Categories : 11i Scripts Tags : , , ,