[Home] [Help]
View: CHV_BUCKET_PATTERNS_VAL_V
View Text
SELECT BUCKET_PATTERN_ID
, BUCKET_PATTERN_NAME
, CBP.DESCRIPTION
, CBP.INACTIVE_DATE
, NUMBER_DAILY_BUCKETS
, NUMBER_WEEKLY_BUCKETS
, NUMBER_MONTHLY_BUCKETS
, NUMBER_QUARTERLY_BUCKETS
, PLC.DISPLAYED_FIELD
FROM CHV_BUCKET_PATTERNS CBP
, PO_LOOKUP_CODES PLC
WHERE SYSDATE < NVL(CBP.INACTIVE_DATE
, SYSDATE + 1)
AND NVL(PLC.LOOKUP_TYPE
, 'DAY_OF_WEEK') = 'DAY_OF_WEEK'
AND PLC.LOOKUP_CODE (+) = WEEK_START_DAY
Columns
Name |
BUCKET_PATTERN_ID |
BUCKET_PATTERN_NAME |
DESCRIPTION |
INACTIVE_DATE |
NUMBER_DAILY_BUCKETS |
NUMBER_WEEKLY_BUCKETS |
NUMBER_MONTHLY_BUCKETS |
NUMBER_QUARTERLY_BUCKETS |
DISPLAYED_FIELD |