eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIL_DIMV_CUSTOMERS

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Customers view
Implementation/DBA Data:	Not implemented in this database

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

Name
CUSTOMER_ID
CUSTOMER_NAME
CUSTOMER_NUMBER
PARTY_TYPE
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
STATE
COUNTRY
COUNTY
PROVINCE
POSTAL_CODE
CREATION_DATE
ID
VALUE