VIEW: APPS.AR_CMGT_DATA_POINTS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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