[Home] [Help]
View: OKX_PARTIES_WITH_ACCTS_V
View Text
SELECT P.PARTY_ID ID1
, '#' ID2
, P.PARTY_NUMBER DESCRIPTION
, P.PARTY_NUMBER PARTY_NUMBER
, DECODE(P.TOTAL_NUM_OF_ORDERS
, 0
, 'PROSPECT'
, 1
, 'CUSTOMER'
, 'CUSTOMER') CUSTOMER_PROSPECT_CODE
, P.PARTY_NAME NAME
, P.PARTY_TYPE PARTY_TYPE
, P.STATUS B_STATUS
, DECODE(P.STATUS
, 'A'
, 'A'
, 'I'
, 'I'
, 'D'
, 'I'
, 'I') 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 IN ('PERSON'
, 'ORGANIZATION')
AND EXISTS (SELECT 'X'
FROM HZ_CUST_ACCOUNTS CA
WHERE CA.PARTY_ID = P.PARTY_ID)
Columns
Name |
ID1 |
ID2 |
DESCRIPTION |
PARTY_NUMBER |
CUSTOMER_PROSPECT_CODE |
NAME |
PARTY_TYPE |
B_STATUS |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
WOMEN_OWNED_FLAG |
SMALL_BUSINESS_FLAG |
MINORITY_GROUP_LOOKUP_CODE |