[Home] [Help]
View: RHX_DP_L_CATEGORY_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT MC.CATEGORY_ID
, MC.CONCATENATED_SEGMENTS
, MC.STRUCTURE_ID
, MC.DESCRIPTION
FROM MTL_CATEGORIES_KFV MC
, MTL_CATEGORY_SETS MCS
WHERE MCS.CATEGORY_SET_ID = RHX_DP.GET_PARAMETER('RHX_DP_P_CATEGORY_SET')
AND MC.STRUCTURE_ID = MCS.STRUCTURE_ID
AND MC.ENABLED_FLAG = 'Y'
AND DECODE( MC.DISABLE_DATE
, NULL
, SYSDATE
, MC.DISABLE_DATE) >= SYSDATE
AND DECODE( MC.START_DATE_ACTIVE
, NULL
, SYSDATE
, MC.START_DATE_ACTIVE) <= SYSDATE
AND DECODE( MC.END_DATE_ACTIVE
, NULL
, SYSDATE
, MC.END_DATE_ACTIVE) >= SYSDATE
Columns
Name |
CATEGORY_ID |
CATEGORY |
STRUCTURE_ID |
DESCRIPTION |