View: OKX_LOCATIONS_V

Product:	OKX - Contracts Integration
Description:	Work location definitions
Implementation/DBA Data:	APPS.OKX_LOCATIONS_V

View Text

SELECT LOC.LOCATION_ID ID1
, '#' ID2
, LOT.LOCATION_CODE NAME
, LOT.DESCRIPTION LOCATION_DESCRIPTION
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LOC.IN_ORGANIZATION_FLAG IN_ORGANIZATION_FLAG
, LOC.INVENTORY_ORGANIZATION_ID ORGANIZATION_ID
, DECODE( LOC.INACTIVE_DATE
, NULL
, NULL
, TRUNC(LOC.INACTIVE_DATE - 1)) END_DATE_ACTIVE
, SYSDATE - 20000 START_DATE_ACTIVE
, DECODE(SIGN(NVL(LOC.INACTIVE_DATE - 1
, SYSDATE) - SYSDATE)
, -1
, 'I'
, 'A') STATUS
, LOC.ADDRESS_LINE_1 ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2 ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3 ADDRESS_LINE_3
, LOC.TOWN_OR_CITY TOWN_OR_CITY
, LOC.COUNTRY COUNTRY
, LOC.POSTAL_CODE POSTAL_CODE
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, NULL
, TOWN_OR_CITY
, NULL
, NULL
, NULL
, POSTAL_CODE
, NULL
, COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG')

Columns