VIEW: APPS.OKX_ORG_PARTIES_V

Source

View Text - Preformatted

SELECT P.PARTY_ID ID1, '#' ID2, P.PARTY_NUMBER DESCRIPTION, P.PARTY_NUMBER PARTY_NUMBER, SUBSTR(arp_addr_label_pkg.format_address( NULL,P.ADDRESS1,P.ADDRESS2,P.ADDRESS3,P.ADDRESS4, P.CITY,P.COUNTY,P.STATE,P.PROVINCE,P.POSTAL_CODE,NULL,P.COUNTRY, NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'N','N',80,1,1),1,80) ADDRESS, P.PARTY_NAME NAME, P.PARTY_TYPE PARTY_TYPE, P.STATUS B_STATUS, p.status STATUS, sysdate START_DATE_ACTIVE, decode(p.status,'I',sysdate,'D',sysdate) END_DATE_ACTIVE, NULL WOMEN_OWNED_FLAG, NULL SMALL_BUSINESS_FLAG, NULL MINORITY_GROUP_LOOKUP_CODE FROM HZ_PARTIES P WHERE P.PARTY_TYPE <> 'PARTY_RELATIONSHIP' AND EXISTS (SELECT 'X' FROM hz_cust_acct_sites cas, hz_cust_accounts ca WHERE ca.party_id = p.party_id AND cas.cust_account_id = ca.cust_account_id )

View Text - HTML Formatted

SELECT P.PARTY_ID ID1
, '#' ID2
, P.PARTY_NUMBER DESCRIPTION
, P.PARTY_NUMBER PARTY_NUMBER
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS( NULL
, P.ADDRESS1
, P.ADDRESS2
, P.ADDRESS3
, P.ADDRESS4
, P.CITY
, P.COUNTY
, P.STATE
, P.PROVINCE
, P.POSTAL_CODE
, NULL
, P.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) ADDRESS
, P.PARTY_NAME NAME
, P.PARTY_TYPE PARTY_TYPE
, P.STATUS B_STATUS
, P.STATUS STATUS
, SYSDATE START_DATE_ACTIVE
, DECODE(P.STATUS
, 'I'
, SYSDATE
, 'D'
, SYSDATE) END_DATE_ACTIVE
, NULL WOMEN_OWNED_FLAG
, NULL SMALL_BUSINESS_FLAG
, NULL MINORITY_GROUP_LOOKUP_CODE
FROM HZ_PARTIES P
WHERE P.PARTY_TYPE <> 'PARTY_RELATIONSHIP'
AND EXISTS (SELECT 'X'
FROM HZ_CUST_ACCT_SITES CAS
, HZ_CUST_ACCOUNTS CA
WHERE CA.PARTY_ID = P.PARTY_ID
AND CAS.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID )