[Home] [Help]
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
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
LOCATION_ID |
SEGMENT1 |
SEGMENT2 |
SEGMENT3 |
SEGMENT4 |
SEGMENT5 |
SEGMENT6 |
SEGMENT7 |
SUMMARY_FLAG |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
PRIMARY_UOM_CODE |