VIEW: APPS.WMS_OBJECTS_RULE_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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