Need to query the GL between two accounts between min and max
Oracle Apps R12
hi,
I need to query the GL between two accounts between min and max accounts, but the data is giving wrong account numbers, for example:
0.0000.000.512010116002.0000.0000.0000 and 9.9999.999.512010116002.9999.0000.0000
its also return other accounts for example:
1.0001.000.115010106002.0001.0000.0000
I expect only the account no 512010116002 ( segment4)
I am using GL_SRS_LEDGER_FLEXFIELD flexfield.
Please guide.