View: JL_CO_GL_ACCOUNTS_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_CO_GL_ACCOUNTS_V

View Text

SELECT B.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, B.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, S.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, V.FLEX_VALUE ACCOUNT
, VT.DESCRIPTION DESCRIPTION
, SUBSTR(V.COMPILED_VALUE_ATTRIBUTES
, DECODE(INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'A')
, 0
, DECODE(INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'E')
, 0
, DECODE(INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'L')
, 0
, DECODE(INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'O')
, 0
, DECODE(INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'R')
, 0
, 0
, INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'R'))
, INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'O'))
, INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'L'))
, INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'E'))
, INSTR(V.COMPILED_VALUE_ATTRIBUTES
, 'A'))
, 1) ACCOUNT_TYPE
, DECODE(LENGTH(V.FLEX_VALUE)
, 1
, 1
, 2
, 2
, 4
, 3
, 4) LEVEL_NUM
, SUBSTR(V.FLEX_VALUE
, 1
, 1) LEVEL1
, SUBSTR(V.FLEX_VALUE
, 2
, 1) LEVEL2
, SUBSTR(V.FLEX_VALUE
, 3
, 2) LEVEL3
, SUBSTR(V.FLEX_VALUE
, 5
, LENGTH(V.FLEX_VALUE)-4) LEVEL4
, SUBSTR(V.FLEX_VALUE
, 1
, 2) LEVEL_ACCOUNT2
, SUBSTR(V.FLEX_VALUE
, 1
, 4) LEVEL_ACCOUNT3
FROM GL_SETS_OF_BOOKS B
, FND_FLEX_VALUES V
, FND_FLEX_VALUES_TL VT
, FND_ID_FLEX_SEGMENTS S
WHERE V.FLEX_VALUE_SET_ID = S.FLEX_VALUE_SET_ID
AND V.FLEX_VALUE_ID = VT.FLEX_VALUE_ID
AND VT.LANGUAGE = 'US'
AND V.ENABLED_FLAG = 'Y'
AND (S.APPLICATION_ID
, S.ID_FLEX_CODE
, S.ID_FLEX_NUM
, S.APPLICATION_COLUMN_NAME) = (SELECT APPLICATION_ID
, ID_FLEX_CODE
, ID_FLEX_NUM
, APPLICATION_COLUMN_NAME
FROM FND_SEGMENT_ATTRIBUTE_VALUES A
WHERE ID_FLEX_CODE = 'GL#'
AND SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND ATTRIBUTE_VALUE = 'Y'
AND APPLICATION_ID = (SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = 'SQLGL')
AND ID_FLEX_NUM = B.CHART_OF_ACCOUNTS_ID)

Columns