View: POS_ASN_LOCATION_LOV_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.POS_ASN_LOCATION_LOV_V

View Text

SELECT HRT.LOCATION_ID
, HRT.LOCATION_CODE
, HRT.ADDRESS_LINE_1 || ' ' || HRT.ADDRESS_LINE_2 || ' ' || HRT.ADDRESS_LINE_3 || ' ' || HRT.TOWN_OR_CITY || ' ' || HRT.REGION_2 || '
, ' || HRT.POSTAL_CODE || ' ' || HRT.COUNTRY
, HRT.INVENTORY_ORGANIZATION_ID
, STO.ORGANIZATION_CODE
, STO.ORGANIZATION_NAME
FROM HR_LOCATIONS HRT
, ORG_ORGANIZATION_DEFINITIONS STO
WHERE HRT.INVENTORY_ORGANIZATION_ID = STO.ORGANIZATION_ID(+)

Columns