VIEW: AMS.AMS_PARTY_MARKET_SEGMENTS#

Source

View Text - Preformatted

select AMS_PARTY_MARKET_SEGMENT_ID AMS_PARTY_MARKET_SEGMENT_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, MARKET_SEGMENT_ID MARKET_SEGMENT_ID, MARKET_SEGMENT_FLAG MARKET_SEGMENT_FLAG, PARTY_ID PARTY_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TERRITORY_ID TERRITORY_ID, MARKET_QUALIFIER_TYPE MARKET_QUALIFIER_TYPE, MARKET_QUALIFIER_REFERENCE MARKET_QUALIFIER_REFERENCE, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, SITE_USE_CODE SITE_USE_CODE, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, ROLLUP_PARTY_ID ROLLUP_PARTY_ID, SITE_USE_ID SITE_USE_ID from "AMS"."AMS_PARTY_MARKET_SEGMENTS"

View Text - HTML Formatted

SELECT AMS_PARTY_MARKET_SEGMENT_ID AMS_PARTY_MARKET_SEGMENT_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
, MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, MARKET_SEGMENT_FLAG MARKET_SEGMENT_FLAG
, PARTY_ID PARTY_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TERRITORY_ID TERRITORY_ID
, MARKET_QUALIFIER_TYPE MARKET_QUALIFIER_TYPE
, MARKET_QUALIFIER_REFERENCE MARKET_QUALIFIER_REFERENCE
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE_USE_CODE SITE_USE_CODE
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, ROLLUP_PARTY_ID ROLLUP_PARTY_ID
, SITE_USE_ID SITE_USE_ID
FROM "AMS"."AMS_PARTY_MARKET_SEGMENTS"