View: AMS_APPROVAL_DETAILS_VL

Product:	AMS - Marketing
Description:	This view returns information about Approval rules
Implementation/DBA Data:	APPS.AMS_APPROVAL_DETAILS_VL

View Text

SELECT B.ROWID ROW_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.APPROVAL_DETAIL_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.SECURITY_GROUP_ID
, B.BUSINESS_GROUP_ID
, B.BUSINESS_UNIT_ID
, B.ORGANIZATION_ID
, B.CUSTOM_SETUP_ID
, B.APPROVAL_OBJECT
, B.APPROVAL_OBJECT_TYPE
, B.APPROVAL_TYPE
, B.APPROVAL_PRIORITY
, B.APPROVAL_LIMIT_TO
, B.APPROVAL_LIMIT_FROM
, B.SEEDED_FLAG
, B.ACTIVE_FLAG
, B.CURRENCY_CODE
, B.USER_COUNTRY_CODE
, T.NAME
, T.DESCRIPTION
FROM AMS_APPROVAL_DETAILS_TL T
, AMS_APPROVAL_DETAILS B
WHERE B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
AND T.LANGUAGE = USERENV('LANG')

Columns