View: BIL_DIMV_CUSTOMERS

Product:	BIL - Sales Intelligence
Description:	Customers view
Implementation/DBA Data:	APPS.BIL_DIMV_CUSTOMERS

View Text

SELECT HP.PARTY_ID
, HP.PARTY_NAME
, HP.PARTY_NUMBER
, HP.PARTY_TYPE
, HP.ADDRESS1
, HP.ADDRESS2
, HP.ADDRESS3
, HP.ADDRESS4
, HP.CITY
, HP.STATE
, HP.COUNTRY
, HP.COUNTY
, HP.PROVINCE
, HP.POSTAL_CODE
, HP.CREATION_DATE
, TO_CHAR(HP.PARTY_ID) ID
, SUBSTR(HP.PARTY_NAME
, 1
, 80) VALUE
FROM HZ_PARTIES HP
WHERE HP.STATUS IN ('A'
, 'I') UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) CUSTOMER_ID
, FL.MEANING CUSTOMER_NAME
, FL.LOOKUP_CODE CUSTOMER_NUMBER
, FL.MEANING PARTY_TYPE
, FL.MEANING ADDRESS1
, FL.MEANING ADDRESS2
, FL.MEANING ADDRESS3
, FL.MEANING ADDRESS4
, FL.MEANING CITY
, FL.MEANING STATE
, FL.MEANING COUNTRY
, FL.MEANING PROVINCE
, FL.MEANING COUNTY
, FL.MEANING POSTAL_CODE
, FL.START_DATE_ACTIVE CREATION_DATE
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns