View: AHL_OWNER_DETAILS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query to retrieve valid owners for an Unit Configuration.
Implementation/DBA Data:	APPS.AHL_OWNER_DETAILS_V

View Text

SELECT PARTY_ID OWNER_ID
, PARTY_NUMBER OWNER_NUMBER
, PARTY_NAME OWNER_NAME
, PARTY_TYPE OWNER_TYPE
, 'PARTY' PARTY_TYPE
, DECODE(ADDRESS1
, NULL
, NULL
, ADDRESS1) || DECODE(ADDRESS2
, NULL
, NULL
, ';'||ADDRESS2) || DECODE(ADDRESS3
, NULL
, NULL
, ';'||ADDRESS3) || DECODE(ADDRESS4
, NULL
, NULL
, ';'||ADDRESS4) || DECODE(CITY
, NULL
, NULL
, ';'|| CITY) || DECODE(POSTAL_CODE
, NULL
, NULL
, ';'||POSTAL_CODE) || DECODE(STATE
, NULL
, NULL
, ';'||STATE) || DECODE(PROVINCE
, NULL
, NULL
, ';'|| PROVINCE) || DECODE(COUNTRY
, NULL
, NULL
, ';'||COUNTRY) ADDRESS
FROM HZ_PARTIES
WHERE STATUS <> 'I'
AND (PARTY_TYPE IN ( 'ORGANIZATION'
, 'PERSON')) UNION ALL SELECT VENDOR_ID OWNER_ID
, SEGMENT1 OWNER_NUMBER
, VENDOR_NAME OWNER_NAME
, VENDOR_TYPE_LOOKUP_CODE OWNER_TYPE
, 'VENDOR' PARTY_TYPE
, NULL ADDRESS
FROM PO_VENDORS

Columns