GL CODE

GL DRILL Down Query From GL into Fixed Assets Sub ledger Module.

The below query will  provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(all sources) sub-ledger modules. SELECT  GCC.concatenated_segments segments,         …

Read More

Drill Down Query From GL into Project Accounting subledger

The below query will  provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accounting sub-ledger modules. SELECT      GLCC.concatenated_segments segments      …

Read More

Create Bulk GL Code Combinations Using API

DECLARE CURSOR c1    IS    SELECT  a.rowid row_id,a.* FROM    temp_gl_code a WHERE   process_flag= ‘N’;                 l_segment1        …

Read More