eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JL_CO_GL_NIT_ACCTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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