View: PSP_LAYOUT_LOOKUP_CODE_V

Product:	PSP - Labor Distribution
Description:
Implementation/DBA Data:	APPS.PSP_LAYOUT_LOOKUP_CODE_V

View Text

SELECT LOOKUP.LOOKUP_CODE
, LOOKUP.MEANING
, -1 SET_OF_BOOKS_ID
FROM FND_LOOKUP_VALUES_VL LOOKUP
WHERE LOOKUP.LOOKUP_TYPE='PSP_SORTING_CRITERIA' UNION SELECT FS.APPLICATION_COLUMN_NAME
, LOOKUP.MEANING ||FS.FORM_LEFT_PROMPT
, GL.SET_OF_BOOKS_ID
FROM FND_ID_FLEX_SEGMENTS_VL FS
, FND_APPLICATION FA
, GL_SETS_OF_BOOKS GL
, FND_LOOKUP_VALUES_VL LOOKUP
WHERE FS.APPLICATION_ID=FA.APPLICATION_ID
AND FA.APPLICATION_SHORT_NAME ='SQLGL'
AND FS.ID_FLEX_NUM=GL.CHART_OF_ACCOUNTS_ID
AND FS.ID_FLEX_CODE='GL#'
AND FS.ENABLED_FLAG='Y'
AND LOOKUP.LOOKUP_TYPE='PSP_GL_SEGMENT_PREFIX'

Columns