View: OKX_ASST_CATGRS_V

Product:	OKX - Contracts Integration
Description:	Contains information about all the asset categories
Implementation/DBA Data:	APPS.OKX_ASST_CATGRS_V

View Text

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

Columns