FND Design Data [Home] [Help]

View: AR_CMGT_SCORABLE_DATA_POINTS_V

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

SELECT DATA_POINT_ID
, DATA_POINT_NAME
, DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, DATA_POINT_CODE
FROM AR_CMGT_DATA_POINTS_VL
WHERE SCORABLE_FLAG = 'Y' UNION SELECT DATA_ELEMENT_ID
, DATA_ELEMENT_NAME
, 'DNB' DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, NULL DATA_POINT_CODE
FROM AR_CMGT_DNB_ELEMENTS_VL
WHERE SCORABLE_FLAG = 'Y'

Columns

Name
DATA_POINT_ID
DATA_POINT_NAME
DATA_POINT_CATEGORY
APPLICATION_ID
RETURN_DATA_TYPE
RETURN_DATE_FORMAT
DATA_POINT_CODE