VIEW: AMS.AMS_APPROVAL_DETAILS#

Source

View Text - Preformatted

select APPROVAL_DETAIL_ID APPROVAL_DETAIL_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, ORGANIZATION_ID ORGANIZATION_ID, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, APPROVAL_OBJECT APPROVAL_OBJECT, APPROVAL_OBJECT_TYPE APPROVAL_OBJECT_TYPE, APPROVAL_TYPE APPROVAL_TYPE, APPROVAL_PRIORITY APPROVAL_PRIORITY, APPROVAL_LIMIT_TO APPROVAL_LIMIT_TO, APPROVAL_LIMIT_FROM APPROVAL_LIMIT_FROM, SEEDED_FLAG SEEDED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ACTIVE_FLAG ACTIVE_FLAG, CURRENCY_CODE CURRENCY_CODE, USER_COUNTRY_CODE USER_COUNTRY_CODE, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_APPROVAL_DETAILS"

View Text - HTML Formatted

SELECT APPROVAL_DETAIL_ID APPROVAL_DETAIL_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, APPROVAL_OBJECT APPROVAL_OBJECT
, APPROVAL_OBJECT_TYPE APPROVAL_OBJECT_TYPE
, APPROVAL_TYPE APPROVAL_TYPE
, APPROVAL_PRIORITY APPROVAL_PRIORITY
, APPROVAL_LIMIT_TO APPROVAL_LIMIT_TO
, APPROVAL_LIMIT_FROM APPROVAL_LIMIT_FROM
, SEEDED_FLAG SEEDED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ACTIVE_FLAG ACTIVE_FLAG
, CURRENCY_CODE CURRENCY_CODE
, USER_COUNTRY_CODE USER_COUNTRY_CODE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_APPROVAL_DETAILS"