VIEW: APPS.BIL_DIMV_CUSTOMERS

Source

View Text - Preformatted

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 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

View Text - HTML Formatted

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 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