VIEW: APPS.AR_REMIT_TO_STATE

Source

View Text - Preformatted

SELECT a.country,a.state,a.state FROM hz_locations a GROUP by a.country, a.state UNION ALL SELECT LOOKUP_CODE,lookup_code ,meaning FROM AR_LOOKUPS L WHERE LOOKUP_TYPE='REMIT'

View Text - HTML Formatted

SELECT A.COUNTRY
, A.STATE
, A.STATE
FROM HZ_LOCATIONS A GROUP BY A.COUNTRY
, A.STATE UNION ALL SELECT LOOKUP_CODE
, LOOKUP_CODE
, MEANING
FROM AR_LOOKUPS L
WHERE LOOKUP_TYPE='REMIT'