VIEW: APPS.OKX_AST_LOCS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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