VIEW: APPS.OKX_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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