[Home] [Help]
View: OE_SHIP_FROM_ORGS_V
View Text
SELECT MP.ORGANIZATION_CODE
, HOU.NAME
, HOU.ORGANIZATION_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MP
, HR_ORGANIZATION_INFORMATION HOI1
WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1= 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
Columns
Name |
ORGANIZATION_CODE |
NAME |
ORGANIZATION_ID |
LOCATION_CODE |
ADDRESS_LINE_1 |
ADDRESS_LINE_2 |
ADDRESS_LINE_3 |
REGION_1 |
REGION_2 |
REGION_3 |
TOWN_OR_CITY |
POSTAL_CODE |
COUNTRY |
LOCATION_ID |