VIEW: APPS.AMS_TAR_ORGANIZATION_V

Source

View Text - Preformatted

SELECT COL2 CUSTOMER_KEY, COL5 DUNS_NUMBER, COL4 JGZZ_FISCAL_CODE, CUSTOMER_NAME ORGANIZATION_NAME, PARTY_ID PARTY_ID, COL1 SIC_CODE, COL6 TAX_NAME, COL3 TAX_REFERENCE, LIST_ENTRY_ID, LIST_HEADER_ID, OBJECT_VERSION_NUMBER, LIST_SELECT_ACTION_ID, ARC_LIST_SELECT_ACTION_FROM, LIST_SELECT_ACTION_FROM_NAME, SOURCE_CODE, ARC_LIST_USED_BY_SOURCE, PIN_CODE, LIST_ENTRY_SOURCE_SYSTEM_ID, LIST_ENTRY_SOURCE_SYSTEM_TYPE,VIEW_APPLICATION_ID, MANUALLY_ENTERED_FLAG,MARKED_AS_DUPLICATE_FLAG, MARKED_AS_RANDOM_FLAG,PART_OF_CONTROL_GROUP_FLAG, ENABLED_FLAG,CELL_CODE,CAMPAIGN_ID,MEDIA_ID, CHANNEL_ID,CHANNEL_SCHEDULE_ID,EVENT_OFFER_ID, LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE, CREATED_BY from ams_list_entries WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE ='AMS_ORGANIZATION'

View Text - HTML Formatted

SELECT COL2 CUSTOMER_KEY
, COL5 DUNS_NUMBER
, COL4 JGZZ_FISCAL_CODE
, CUSTOMER_NAME ORGANIZATION_NAME
, PARTY_ID PARTY_ID
, COL1 SIC_CODE
, COL6 TAX_NAME
, COL3 TAX_REFERENCE
, LIST_ENTRY_ID
, LIST_HEADER_ID
, OBJECT_VERSION_NUMBER
, LIST_SELECT_ACTION_ID
, ARC_LIST_SELECT_ACTION_FROM
, LIST_SELECT_ACTION_FROM_NAME
, SOURCE_CODE
, ARC_LIST_USED_BY_SOURCE
, PIN_CODE
, LIST_ENTRY_SOURCE_SYSTEM_ID
, LIST_ENTRY_SOURCE_SYSTEM_TYPE
, VIEW_APPLICATION_ID
, MANUALLY_ENTERED_FLAG
, MARKED_AS_DUPLICATE_FLAG
, MARKED_AS_RANDOM_FLAG
, PART_OF_CONTROL_GROUP_FLAG
, ENABLED_FLAG
, CELL_CODE
, CAMPAIGN_ID
, MEDIA_ID
, CHANNEL_ID
, CHANNEL_SCHEDULE_ID
, EVENT_OFFER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE ='AMS_ORGANIZATION'