Pulling Account Entry Details from GL_JE_Lines
Hello,
Note: We are using 11i
I'm trying to pull account details of journal entries entered into the GL for specific business units. In our structure, Segment 1 in the chart of accounts is a business unit identifier. When I searched the GL_JE_Lines table, I could not find the account (segment) numbers. Rather, the only field that I could link between the chart of accounts and GL_JE_Lines is the 'Code_Combination_ID' field. I can join the tables, however I was wondering if there is another table I should be searching that would already have the account (segment) numbers. Any help is greatly appreciated. Thanks in advance!