View: WMS_OBJECTS_RULE_LOV_V

Product:	WMS - Warehouse Management
Description:	WMS business object LOV view
Implementation/DBA Data:	APPS.WMS_OBJECTS_RULE_LOV_V

View Text

SELECT WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, MAX(WPVL.USE_FOR_PUT_SORT_FLAG)
, MAX(WPVL.USE_FOR_PUT_REST_FLAG)
, MAX(WPVL.USE_FOR_PUT_QTYF_FLAG)
, MAX(WPVL.USE_FOR_PICK_SORT_FLAG)
, MAX(WPVL.USE_FOR_PICK_REST_FLAG)
, MAX(WPVL.USE_FOR_PICK_QTYF_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_PICK_CONSIST_FLAG)
, MAX(WPVL.USE_FOR_OP_SELECTION_FLAG)
, AVG(DECODE(WPVL.USE_FOR_OP_SELECTION_FLAG
, 'Y'
, NVL(WPVL.RULE_SUBTYPE_CODE
, 1.5)
, NULL)) RULE_SUBTYPE_CODE
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

Columns