View: JL_CO_GL_NIT_ACCTS_V

Product:	JL - Latin America Localizations
Description:	N/A
Implementation/DBA Data:	APPS.JL_CO_GL_NIT_ACCTS_V

View Text

SELECT JLCGNA.ROWID ROW_ID
, JLCGNA.CHART_OF_ACCOUNTS_ID
, JLCGNA.FLEX_VALUE_ID
, JLCGNA.ACCOUNT_CODE
, JLCGNA.CREATED_BY
, JLCGNA.LAST_UPDATE_DATE
, JLCGNA.LAST_UPDATED_BY
, JLCGNA.CREATION_DATE
, JLCGNA.LAST_UPDATE_LOGIN
, JLCGNA.NIT_REQUIRED
, JLCGNA.ATTRIBUTE_CATEGORY
, JLCGNA.ATTRIBUTE1
, JLCGNA.ATTRIBUTE2
, JLCGNA.ATTRIBUTE3
, JLCGNA.ATTRIBUTE4
, JLCGNA.ATTRIBUTE5
, JLCGNA.ATTRIBUTE6
, JLCGNA.ATTRIBUTE7
, JLCGNA.ATTRIBUTE8
, JLCGNA.ATTRIBUTE9
, JLCGNA.ATTRIBUTE10
, JLCGNA.ATTRIBUTE11
, JLCGNA.ATTRIBUTE12
, JLCGNA.ATTRIBUTE13
, JLCGNA.ATTRIBUTE14
, JLCGNA.ATTRIBUTE15
, FNDL.MEANING ACCOUNT_TYPE
, FNDFVV.DESCRIPTION
FROM FND_LOOKUPS FNDL
, FND_FLEX_VALUES_VL FNDFVV
, FND_FLEX_VALUES FNDFV
, JL_CO_GL_NIT_ACCTS JLCGNA
WHERE JLCGNA.FLEX_VALUE_ID = FNDFV.FLEX_VALUE_ID
AND FNDFV.FLEX_VALUE_ID = FNDFVV.FLEX_VALUE_ID
AND FNDL.LOOKUP_TYPE = 'ACCOUNT_TYPE'
AND SUBSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, DECODE(INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'A')
, 0
, DECODE(INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'E')
, 0
, DECODE(INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'L')
, 0
, DECODE(INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'O')
, 0
, DECODE(INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'R')
, 0
, 0
, INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'R'))
, INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'O'))
, INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'L'))
, INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'E'))
, INSTR(FNDFV.COMPILED_VALUE_ATTRIBUTES
, 'A'))
, 1) = FNDL.LOOKUP_CODE

Columns