FND Design Data [Home] [Help]

View: AR_CMGT_DATA_POINTS_VL

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.AR_CMGT_DATA_POINTS_VL
View Text

SELECT B.ROWID ROW_ID
, B.DATA_POINT_ID
, T.DATA_POINT_NAME
, B.DATA_POINT_CATEGORY
, T.DESCRIPTION
, B.USER_DEFINED_FLAG
, B.SCORABLE_FLAG
, B.DISPLAY_ON_CHECKLIST_FLAG
, B.APPLICATION_ID
, APP.APPLICATION_NAME
, NVL(B.ENABLED_FLAG
, 'N') ENABLED_FLAG
, B.PACKAGE_NAME
, B.FUNCTION_NAME
, B.PARENT_DATA_POINT_ID
, B.DATA_POINT_SUB_CATEGORY
, B.FUNCTION_TYPE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, B.RETURN_DATA_TYPE
, B.RETURN_DATE_FORMAT
, B.DATA_POINT_CODE
FROM AR_CMGT_DATA_POINTS_B B
, AR_CMGT_DATA_POINTS_TL T
, FND_APPLICATION_VL APP
WHERE B.DATA_POINT_ID = T.DATA_POINT_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.APPLICATION_ID = APP.APPLICATION_ID

Columns

Name
ROW_ID
DATA_POINT_ID
DATA_POINT_NAME
DATA_POINT_CATEGORY
DESCRIPTION
USER_DEFINED_FLAG
SCORABLE_FLAG
DISPLAY_ON_CHECKLIST_FLAG
APPLICATION_ID
APPLICATION_NAME
ENABLED_FLAG
PACKAGE_NAME
FUNCTION_NAME
PARENT_DATA_POINT_ID
DATA_POINT_SUB_CATEGORY
FUNCTION_TYPE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
RETURN_DATA_TYPE
RETURN_DATE_FORMAT
DATA_POINT_CODE