VIEW: APPS.WMS_OBJECTS_OPERAND_LOV_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)