Product: | WMS - Warehouse Management |
---|---|
Description: | WMS business object LOV view |
Implementation/DBA Data: | APPS.WMS_OBJECTS_RULE_LOV_V |
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