VIEW: APPS.AHL_OWNER_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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