Current Period Status of Application (oracle 11i)

Posted by Jiltin     Tags: , , , 10 November, 2008    431 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 : , , ,

Receipt Status – Oracle Applications

Posted by Jiltin     Tags: , 13 October, 2008    691 views    (0) Comment

A receipt can have one of the following statuses: Approved: This receipt has been approved for automatic receipt creation. This status is only valid for automatic receipts. Confirmed: The customer has approved the application of this receipt and their account balances have been updated within Receivables. This status is only valid for automatic receipts. Remitted: This receipt has been remitted. This status is valid for both automatic and manually entered receipts. Cleared: The payment of Read Full Article (Click here)...

Categories : Oracle Applications Tags : ,