[Home] [Help]
View: MRP_AP_CATEGORY_SETS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT MCSB.CATEGORY_SET_ID
, MCST.CATEGORY_SET_NAME
, MCST.DESCRIPTION
, MCSB.CONTROL_LEVEL
, DECODE( MDCS.CATEGORY_SET_ID
, NULL
, 2
, 1) DEFAULT_FLAG
, MCST.LANGUAGE
, MCSB.RN RN1
FROM MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_CATEGORY_SETS_TL MCST
, MRP_AP_CATG_SETS_SN MCSB
WHERE MDCS.CATEGORY_SET_ID(+)= MCSB.CATEGORY_SET_ID
AND MDCS.FUNCTIONAL_AREA_ID(+)= 3
AND MCSB.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID
Columns
Name |
CATEGORY_SET_ID |
CATEGORY_SET_NAME |
DESCRIPTION |
CONTROL_LEVEL |
DEFAULT_FLAG |
LANGUAGE |
RN1 |