VIEW: APPS.OKX_ASST_CATGRS_V

Source

View Text - Preformatted

SELECT B.CATEGORY_ID, '#', decode(B.segment1,null,null,ltrim(rtrim(B.segment1,' '),' '))|| decode(B.segment2,null,null,'.'||ltrim(rtrim(B.segment2,' '),' '))|| decode(B.segment3,null,null,'.'||ltrim(rtrim(B.segment3,' '),' '))|| decode(B.segment4,null,null,'.'||ltrim(rtrim(B.segment4,' '),' '))|| decode(B.segment5,null,null,'.'||ltrim(rtrim(B.segment5,' '),' '))|| decode(B.segment6,null,null,'.'||ltrim(rtrim(B.segment6,' '),' '))|| decode(B.segment7,null,null,'.'||ltrim(rtrim(B.segment7,' '),' ')) NAME, TL.DESCRIPTION DESCRIPTION, B.CATEGORY_ID CATEGORY_ID, B.SUMMARY_FLAG SUMMARY_FLAG, B.ENABLED_FLAG ENABLED_FLAG, B.OWNED_LEASED OWNED_LEASED, B.CATEGORY_TYPE CATEGORY_TYPE, B.CAPITALIZE_FLAG CAPITALIZE_FLAG, B.SEGMENT1 SEGMENT1, B.SEGMENT2 SEGMENT2, B.SEGMENT3 SEGMENT3, B.SEGMENT4 SEGMENT4, B.SEGMENT5 SEGMENT5, B.SEGMENT6 SEGMENT6, B.SEGMENT7 SEGMENT7, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(B.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(B.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, NULL PRIMARY_UOM_CODE, B.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE, B.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE, B.DATE_INEFFECTIVE DATE_INEFFECTIVE, B.PRODUCTION_CAPACITY PRODUCTION_CAPACITY, B.INVENTORIAL INVENTORIAL FROM FA_CATEGORIES_B B,FA_CATEGORIES_TL TL WHERE B.CATEGORY_ID = TL.CATEGORY_ID and TL.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT B.CATEGORY_ID
, '#'
, DECODE(B.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(B.SEGMENT1
, ' ')
, ' '))|| DECODE(B.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT2
, ' ')
, ' '))|| DECODE(B.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT3
, ' ')
, ' '))|| DECODE(B.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT4
, ' ')
, ' '))|| DECODE(B.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT5
, ' ')
, ' '))|| DECODE(B.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT6
, ' ')
, ' '))|| DECODE(B.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(B.SEGMENT7
, ' ')
, ' ')) NAME
, TL.DESCRIPTION DESCRIPTION
, B.CATEGORY_ID CATEGORY_ID
, B.SUMMARY_FLAG SUMMARY_FLAG
, B.ENABLED_FLAG ENABLED_FLAG
, B.OWNED_LEASED OWNED_LEASED
, B.CATEGORY_TYPE CATEGORY_TYPE
, B.CAPITALIZE_FLAG CAPITALIZE_FLAG
, B.SEGMENT1 SEGMENT1
, B.SEGMENT2 SEGMENT2
, B.SEGMENT3 SEGMENT3
, B.SEGMENT4 SEGMENT4
, B.SEGMENT5 SEGMENT5
, B.SEGMENT6 SEGMENT6
, B.SEGMENT7 SEGMENT7
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, B.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, B.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, B.DATE_INEFFECTIVE DATE_INEFFECTIVE
, B.PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, B.INVENTORIAL INVENTORIAL
FROM FA_CATEGORIES_B B
, FA_CATEGORIES_TL TL
WHERE B.CATEGORY_ID = TL.CATEGORY_ID
AND TL.LANGUAGE=USERENV('LANG')