Hello everyone, I'm having difficulty getting my code to select data in the reports, specifically the 'Conta'(Account) regarding the FLEX_VALUE field.
cod01
SELECT
GL_CODE_COMBINATIONS.SEGMENT1 AS Empresa,
GL_CODE_COMBINATIONS.SEGMENT3 AS Conta,
SUM(GL_JE_LINES.ACCOUNTED_DR) AS DR_Contabilizado
FROM
GL_JE_HEADERS
JOIN GL_JE_LINES ON GL_JE_HEADERS.JE_HEADER_ID = GL_JE_LINES.JE_HEADER_ID
JOIN GL_CODE_COMBINATIONS ON GL_JE_LINES.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
JOIN gl_je_batches ON gl_je_batches.je_batch_id = GL_JE_HEADERS.je_batch_id
JOIN GL_LEDGERS ON GL_LEDGERS.LEDGER_ID = GL_JE_HEADERS.LEDGER_ID
WHERE
GL_JE_HEADERS.default_effective_date >= '2024-01-01'
AND GL_JE_HEADERS.default_effective_date <= '2024-01-31'
and GL_JE_HEADERS.PERIOD_NAME <> '01_Jan-24'
AND GL_LEDGERS.NAME = 'PE_COA PE'
GROUP BY
GL_CODE_COMBINATIONS.SEGMENT1,
GL_CODE_COMBINATIONS.SEGMENT3
ORDER BY
GL_CODE_COMBINATIONS.SEGMENT3
cod02
SELECT A.FLEX_VALUE,C.DESCRIPTION
FROM FND_FLEX_VALUE_SETS B,
FND_FLEX_VALUES A,
FND_FLEX_VALUES_TL C
WHERE B.FLEX_VALUE_SET_NAME = 'CONTA PE_COA'
AND B.FLEX_VALUE_SET_ID = A.FLEX_VALUE_SET_ID
AND A.ENABLED_FLAG = 'Y'
AND A.FLEX_VALUE_ID = C.FLEX_VALUE_ID (+)
AND C.LANGUAGE (+) = 'PTB'