VIEW: APPS.OKX_PARTIES_V

Source

View Text - Preformatted

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, 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, NULL PRIMARY_UOM_CODE , P.GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG, P.COUNTRY COUNTRY, P.ADDRESS1 ADDRESS1, P.ADDRESS2 ADDRESS2, P.ADDRESS3 ADDRESS3, P.ADDRESS4 ADDRESS4, P.CITY CITY, P.POSTAL_CODE POSTAL_CODE, P.STATE STATE, P.PROVINCE PROVINCE, P.COUNTY COUNTY FROM HZ_PARTIES P WHERE P.PARTY_TYPE IN ( 'PERSON','ORGANIZATION')

View Text - HTML Formatted

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
, 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
, NULL PRIMARY_UOM_CODE
, P.GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG
, P.COUNTRY COUNTRY
, P.ADDRESS1 ADDRESS1
, P.ADDRESS2 ADDRESS2
, P.ADDRESS3 ADDRESS3
, P.ADDRESS4 ADDRESS4
, P.CITY CITY
, P.POSTAL_CODE POSTAL_CODE
, P.STATE STATE
, P.PROVINCE PROVINCE
, P.COUNTY COUNTY
FROM HZ_PARTIES P
WHERE P.PARTY_TYPE IN ( 'PERSON'
, 'ORGANIZATION')