SELECT ORGANIZATION_ID, ORGANIZATION_CODE, ORGANIZATION_NAME, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, COUNTRY, ZIP_CODE, CITY || ', ' || STATE || ' ' || ZIP_CODE, SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME, SYMBOL, ORG_INFO, VALUE FROM MTL_ORGANIZATIONS
SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, CITY
, STATE
, COUNTRY
, ZIP_CODE
, CITY || '
, ' || STATE || ' ' || ZIP_CODE
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, SYMBOL
, ORG_INFO
, VALUE
FROM MTL_ORGANIZATIONS
|
|
|