View: AS_FREIGHT_CARRIERS_ACTIVE_V

View Text

SELECT F.FREIGHT_CODE
, F.DESCRIPTION
, 'OE'
, O.ORGANIZATION_NAME
FROM ORG_FREIGHT_VL F
, ORG_ORGANIZATION_DEFINITIONS O
WHERE ( (F.DISABLE_DATE IS NULL) OR (F.DISABLE_DATE > SYSDATE))
AND F.ORGANIZATION_ID = O.ORGANIZATION_ID(+) UNION SELECT LOOKUP_CODE
, MEANING
, 'OSM'
, NULL
FROM AS_LOOKUPS
WHERE LOOKUP_TYPE = 'FREIGHT_CARRIER'
AND ENABLED_FLAG = 'Y'

Columns