View: WIP_LINES_VAL_V

Product:	WIP - Work in Process
Description:	Enabled production lines
Implementation/DBA Data:	APPS.WIP_LINES_VAL_V

View Text

SELECT LINE_ID
, LINE_CODE
, ORGANIZATION_ID
, DESCRIPTION
, MINIMUM_RATE
, MAXIMUM_RATE
, LINE_SCHEDULE_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ROUND((MAXIMUM_RATE*DECODE(SIGN(STOP_TIME - START_TIME)
, -1
, 86400 + STOP_TIME - START_TIME
, 0
, 86400
, STOP_TIME - START_TIME) / 3600)
, 6) DAILY_MAXIMUM_RATE
FROM WIP_LINES
WHERE NVL(DISABLE_DATE
, SYSDATE + 1) > SYSDATE

Columns