Showing posts with label set of books in r12. Show all posts
Showing posts with label set of books in r12. Show all posts

How to pass Sets of Books ID and Org ID to the Concurrent Program Report

Name
Value Set
Default SQL Statement
Set of Books ID
AR_CHART_OF_ACCOUNTS_NO_VALIDATION
select sb.set_of_books_id    
from  
gl_sets_of_books sb, ar_system_parameters sp  
where  sb.set_of_books_id = sp.set_of_books_id
Org ID
MULTI_ORG_ID
select org_id from ar_system_parameters