R12 GL SCRIPTS

--GL QUERIES R12


SELECT * FROM GL.GL_JE_BATCHES WHERE NAME LIKE 'AAGRA7_BATCH Payables A 204981 19501478';

SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID = 210086;

SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID = 263237;

SELECT * FROM GL_IMPORT_REFERENCES WHERE JE_BATCH_ID = 210086;

select * from GL_BALANCES;

SELECT * FROM AP.AP_TRIAL_BALANCE WHERE INVOICE_ID=1181871;

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME ='AP_TRIAL_BALANCE';

SELECT * FROM GL.GL_LEGAL_ENTITIES_BSVS;

SELECT * FROM GL.GL_LEDGERS;

SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE '%LEGAL%ENTITY%';

SELECT * FROM GL_LEDGER_SETS_V;


SELECT * FROM GL_TRANSLATION_RATES WHERE SET_OF_BOOKS_ID=4 AND PERIOD_NAME LIKE '%12';

--************************************************

SELECT * FROM GL_CONSOLIDATION where name like 'INR TO INR(US GAAP)';

SELECT * FROM GL_CONSOLIDATION_HISTORY WHERE CONSOLIDATION_ID=1007 AND FROM_PERIOD_NAME='MAY-12';

SELECT * FROM GL_CONS_BATCHES where JE_BATCH_ID=210146;

select * from GL_JE_BATCHES where name like '03-MAY-12 INR TO INR(US GAAP) Consolidation A 205020 %';

SELECT * FROM GL_JE_BATCHES WHERE JE_BATCH_ID=210146;


--*******************************************************************