Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
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