View: WMS_OBJECTS_OPERAND_LOV_V

Product:	WMS - Warehouse Management
Description:	WMS restriction right operand LOV view
Implementation/DBA Data:	APPS.WMS_OBJECTS_OPERAND_LOV_V

View Text

SELECT 4
, WOVL.NAME
, WOVL.DESCRIPTION
, WPVL.OBJECT_ID
, MAX(WPVL.USE_FOR_PUT_REST_FLAG)
, MAX(WPVL.USE_FOR_PICK_REST_FLAG)
, MAX(WPVL.USE_FOR_TT_ASSN_FLAG)
, MAX(WPVL.USE_FOR_LABEL_REST_FLAG)
, MAX(WPVL.USE_FOR_CG_REST_FLAG)
, MAX(WPVL.USE_FOR_OP_SELECTION_FLAG)
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
WHERE WOVL.OBJECT_ID = WPVL.OBJECT_ID GROUP BY WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION UNION ALL SELECT ML.LOOKUP_CODE
, ML.MEANING
, ML.DESCRIPTION
, TO_NUMBER(NULL)
, 'Y'
, 'Y'
, 'Y'
, 'Y'
, 'Y'
, 'Y'
FROM MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE = 'WMS_OPERAND_TYPE'
AND ML.LOOKUP_CODE NOT IN (4
, 7)

Columns