[Home] [Help]
View: IC_TAXN_CLS_VW
Product: | GMI - Process Manufacturing Inventory |
Description: | This view is used for backward compatibility for tax classes. |
Implementation/DBA Data: |
APPS.IC_TAXN_CLS_VW
|
View Text
SELECT SUBSTRB(C.CATEGORY_CONCAT_SEGS
, 1
, 8)
, C.CATEGORY_ID
, SUBSTRB(C.DESCRIPTION
, 1
, 70)
, C.CREATION_DATE
, C.LAST_UPDATE_DATE
, C.CREATED_BY
, C.LAST_UPDATED_BY
, 0
, DECODE(C.DISABLE_DATE
, NULL
, 0
, 1)
, TO_NUMBER(NULL)
, C.LAST_UPDATE_LOGIN
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
WHERE OCS.OPM_CLASS = 'TAX_CLASS'
AND OCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND C.CATEGORY_CONCAT_SEGS = UPPER(SUBSTRB(C.CATEGORY_CONCAT_SEGS
, 1
, 8))
Columns
Name |
ICTAX_CLASS |
TAX_CATEGORY_ID |
ICTAX_CLASS_DESC |
CREATION_DATE |
LAST_UPDATE_DATE |
CREATED_BY |
LAST_UPDATED_BY |
IN_USE |
DELETE_MARK |
TEXT_CODE |
LAST_UPDATE_LOGIN |