VIEW: APPS.OKX_STATES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')