GL Handy SQL’s –
Posted by
Jay 15 June, 2008 430 views
- Current Period Status of Application (oracle 11i)
- Whether GL Period is open or not as of sysdate?
- How To Identify All Requisitions And Purchase Orders With Errored Activities
- Oracle Applications – Acoounts Receivables (AR) Tables Information.
- Locks on oracle database & Oracle applications Processing.
How do I obtain CCID ( code combination id) / Chart of Account data for General Ledger
SELECT
substr(gl.code_combination_id,1,5) ccid,
substr(gl.segment1,1,5) ,
substr(gl.segment2,1,8) ,
substr(gl.segment3,1,5) ,
substr(gl.segment4,1,5) ,
substr(gl.segment5,1,5) ,
substr(gl.segment6,1,5) ,
substr(gl.segment7,1,5) ,
substr(gl.segment8,1,5)
FROM gl.gl_code_combinations gl
ORDER BY code_combination_id;
substr(gl.code_combination_id,1,5) ccid,
substr(gl.segment1,1,5) ,
substr(gl.segment2,1,8) ,
substr(gl.segment3,1,5) ,
substr(gl.segment4,1,5) ,
substr(gl.segment5,1,5) ,
substr(gl.segment6,1,5) ,
substr(gl.segment7,1,5) ,
substr(gl.segment8,1,5)
FROM gl.gl_code_combinations gl
ORDER BY code_combination_id;
How TO find your current GL Period END DATE
SELECT a.END_DATE
FROM GL_PERIOD_STATUSES a
WHERE a.application_id = ‘222′
AND a.closing_status = ‘O’
AND a.start_date = (SELECT max(b.start_date)
FROM gl_period_statuses b
WHERE b.application_id = ‘222′
AND b.closing_status = ‘O’);
What is my current GL Period?
select max(gl_date) from ra_cust_trx_line_gl_dist_all;
Categories :
11i Scripts, Scripts Unix
Comments
No comments yet.