View: CHV_BUCKET_PATTERNS_VAL_V

Product:	CHV - Supplier Scheduling
Description:	- Retrofitted
Implementation/DBA Data:	APPS.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