View: OKX_STATES_V

Product:	OKX - Contracts Integration
Description:	This view contains information about geographical areas. It is based on JTF_LOCATIONS_B
Implementation/DBA Data:	APPS.OKX_STATES_V

View Text

SELECT JLA.LOCATION_AREA_ID ID1
, '#' ID2
, TL.LOCATION_AREA_NAME NAME
, TL.LOCATION_AREA_DESCRIPTION DESCRIPTION
, JLA.LOCATION_AREA_ID LOCATION_AREA_ID
, JLA.ORIG_SYSTEM_ID ORIG_SYSTEM_ID
, JLA.ORIG_SYSTEM_REF ORIG_SYSTEM_REF
, JLA.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, JLA.LOCATION_AREA_CODE LOCATION_AREA_CODE
, JLA.PARENT_LOCATION_AREA_ID PARENT_LOCATION_AREA_ID
, JLA.SECURITY_GROUP_ID SECURITY_GROUP_ID
, JLA.START_DATE_ACTIVE START_DATE_ACTIVE
, JLA.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(JLA.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(JLA.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
FROM JTF_LOC_AREAS_B JLA
, JTF_LOC_AREAS_TL TL
WHERE TL.LOCATION_AREA_ID = JLA.LOCATION_AREA_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns