View: OKX_AST_LOCS_V

Product:	OKX - Contracts Integration
Description:	This view stores valid location flexfield segment value combinations
Implementation/DBA Data:	APPS.OKX_AST_LOCS_V

View Text

SELECT LOC.LOCATION_ID ID1
, '#' ID2
, DECODE(LOC.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(LOC.SEGMENT1
, ' ')
, ' '))|| DECODE(LOC.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT2
, ' ')
, ' '))|| DECODE(LOC.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT3
, ' ')
, ' '))|| DECODE(LOC.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT4
, ' ')
, ' '))|| DECODE(LOC.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT5
, ' ')
, ' '))|| DECODE(LOC.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT6
, ' ')
, ' '))|| DECODE(LOC.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(LOC.SEGMENT7
, ' ')
, ' ')) NAME
, '#' DESCRIPTION
, LOC.LOCATION_ID LOCATION_ID
, LOC.SEGMENT1 SEGMENT1
, LOC.SEGMENT2 SEGMENT2
, LOC.SEGMENT3 SEGMENT3
, LOC.SEGMENT4 SEGMENT4
, LOC.SEGMENT5 SEGMENT5
, LOC.SEGMENT6 SEGMENT6
, LOC.SEGMENT7 SEGMENT7
, LOC.SUMMARY_FLAG SUMMARY_FLAG
, LOC.ENABLED_FLAG ENABLED_FLAG
, LOC.START_DATE_ACTIVE START_DATE_ACTIVE
, LOC.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(LOC.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(LOC.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_LOCATIONS LOC

Columns