[Home] [Help]
View: POS_ORG_ADDRESS_V
View Text
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
Columns
Name |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
CITY |
STATE |
COUNTRY |
ZIP_CODE |
CITY_STATE_ZIP |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
SYMBOL |
ORG_INFO |
VALUE |