VIEW: APPS.IEX_PLIST_ORGS_UWQ_V

Source

View Text - Preformatted

SELECT DISTINCT 'IEXRCALL' IEU_OBJECT_FUNCTION ,'PARTY_ID=&ID ' IEU_OBJECT_PARAMETERS ,'' IEU_MEDIA_TYPE_UUID ,'PARTY' IEU_ACTION_OBJECT_CODE ,'PARTY_ID' IEU_PARAM_PK_COL ,TO_CHAR(PARTY.PARTY_ID) IEU_PARAM_PK_VALUE ,'RS_INDIVIDUAL' RESOURCE_TYPE ,NULL SCHEDULE_ID ,NULL SCHEDULE_NAME ,NULL STATUS_CODE ,NULL SOURCE_CODE ,ALH.OWNER_USER_ID RESOURCE_ID ,ALH.LIST_NAME ,ALH.LIST_HEADER_ID ,ALH.LIST_SOURCE_TYPE ,ALH.LIST_SOURCE ,ALH.ENABLED_FLAG ,ALH.LIST_TYPE ,ALE.LIST_ENTRY_ID ,NULL SUFFIX ,PARTY.PARTY_ID , party.party_number , PARTY.PARTY_NAME , null, to_number(null) cust_account_id, PARTY.ADDRESS1|| PARTY.ADDRESS2|| PARTY.ADDRESS3|| PARTY.ADDRESS4 ADDRESS , PARTY.CITY , PARTY.COUNTY , PARTY.STATE , PARTY.POSTAL_CODE , PARTY.PROVINCE , PARTY.COUNTRY , FTT.TERRITORY_SHORT_NAME country_name , PARTY.EMAIL_ADDRESS , PARTY.STATUS , ALK.MEANING status_mean, PARTY.URL ,ALE.CREATION_DATE ,ALE.LAST_UPDATE_DATE ,ALE.MARKED_AS_DUPLICATE_FLAG ,ALE.PART_OF_CONTROL_GROUP_FLAG FROM AMS_LIST_HEADERS_VL ALH, AMS_LIST_ENTRIES ALE, HZ_PARTIES PARTY , FND_TERRITORIES_TL FTT , AR_LOOKUPS ALK WHERE ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID AND ALH.LIST_HEADER_ID +0 = ALE.LIST_HEADER_ID AND ALE.OUTCOME_ID IS NULL AND to_char(PARTY.PARTY_ID) = ALE.COL200 AND PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+) AND FTT.LANGUAGE(+) = userenv('LANG') AND FTT.SOURCE_LANG(+) = userenv('LANG') AND ALK.LOOKUP_TYPE = 'CODE_STATUS' AND ALK.LOOKUP_CODE = PARTY.STATUS AND PARTY.STATUS IN ('A','I')

View Text - HTML Formatted

SELECT DISTINCT 'IEXRCALL' IEU_OBJECT_FUNCTION
, 'PARTY_ID=&ID ' IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'PARTY' IEU_ACTION_OBJECT_CODE
, 'PARTY_ID' IEU_PARAM_PK_COL
, TO_CHAR(PARTY.PARTY_ID) IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, NULL SCHEDULE_ID
, NULL SCHEDULE_NAME
, NULL STATUS_CODE
, NULL SOURCE_CODE
, ALH.OWNER_USER_ID RESOURCE_ID
, ALH.LIST_NAME
, ALH.LIST_HEADER_ID
, ALH.LIST_SOURCE_TYPE
, ALH.LIST_SOURCE
, ALH.ENABLED_FLAG
, ALH.LIST_TYPE
, ALE.LIST_ENTRY_ID
, NULL SUFFIX
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, NULL
, TO_NUMBER(NULL) CUST_ACCOUNT_ID
, PARTY.ADDRESS1|| PARTY.ADDRESS2|| PARTY.ADDRESS3|| PARTY.ADDRESS4 ADDRESS
, PARTY.CITY
, PARTY.COUNTY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME
, PARTY.EMAIL_ADDRESS
, PARTY.STATUS
, ALK.MEANING STATUS_MEAN
, PARTY.URL
, ALE.CREATION_DATE
, ALE.LAST_UPDATE_DATE
, ALE.MARKED_AS_DUPLICATE_FLAG
, ALE.PART_OF_CONTROL_GROUP_FLAG
FROM AMS_LIST_HEADERS_VL ALH
, AMS_LIST_ENTRIES ALE
, HZ_PARTIES PARTY
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
WHERE ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID
AND ALH.LIST_HEADER_ID +0 = ALE.LIST_HEADER_ID
AND ALE.OUTCOME_ID IS NULL
AND TO_CHAR(PARTY.PARTY_ID) = ALE.COL200
AND PARTY.PARTY_TYPE = 'ORGANIZATION'
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = PARTY.STATUS
AND PARTY.STATUS IN ('A'
, 'I')