Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_ORG_DM_SOURCE_V |
SELECT ADS.SOURCE_ID
, ADS.LAST_UPDATE_DATE
, ADS.LAST_UPDATED_BY
, ADS.CREATION_DATE
, ADS.CREATED_BY
, ADS.LAST_UPDATE_LOGIN
, ADS.OBJECT_VERSION_NUMBER
, ADS.MODEL_TYPE
, ADS.ARC_USED_FOR_OBJECT
, ADS.USED_FOR_OBJECT_ID
, ADS.PARTY_ID
, ADS.TARGET_VALUE
, ADS.SCORE_RESULT
, ADS.CONFIDENCE
, ADS.CONTINUOUS_SCORE
, ADS.CREATED_BY CREATED_BY_NAME
, ADS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, ADS.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM AMS_DM_SOURCE ADS
, HZ_PARTIES HP
WHERE ADS.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'