VIEW: APPS.WMS_PARAMETERS_LOV_V

Source

View Text - Preformatted

SELECT wpvl.PARAMETER_ID ,WMS_Parameter_PVT.GetFlexName( wpvl.NAME ,wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ) ,wpvl.DESCRIPTION ,wpvl.OBJECT_ID ,wovl.NAME ,wovl.DESCRIPTION , wdo.TABLE_ALIAS , wdo.TABLE_NAME ,NVL( wpvl.COLUMN_NAME, 'Expression') ,WMS_Parameter_PVT.GetFlexDataTypeCode( wpvl.DATA_TYPE_CODE ,wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ) ,wpvl.USE_FOR_PUT_SORT_FLAG ,wpvl.USE_FOR_PUT_REST_FLAG ,wpvl.USE_FOR_PUT_QTYF_FLAG ,wpvl.USE_FOR_PICK_SORT_FLAG ,wpvl.USE_FOR_PICK_REST_FLAG ,wpvl.USE_FOR_PICK_QTYF_FLAG ,wpvl.USE_FOR_TT_ASSN_FLAG ,wpvl.USE_FOR_LABEL_REST_FLAG ,wpvl.USE_FOR_CG_REST_FLAG ,wpvl.USE_FOR_PICK_CONSIST_FLAG ,wpvl.USE_FOR_OP_SELECTION_FLAG FROM WMS_OBJECTS_VL wovl ,WMS_PARAMETERS_VL wpvl , WMS_DB_OBJECTS wdo WHERE WMS_Parameter_PVT.IfFlexThenAvailable( wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ) = 'Y' AND wovl.OBJECT_ID = wpvl.OBJECT_ID AND wpvl.DB_OBJECT_ID = wdo.DB_OBJECT_ID (+)

View Text - HTML Formatted

SELECT WPVL.PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WDO.TABLE_ALIAS
, WDO.TABLE_NAME
, NVL( WPVL.COLUMN_NAME
, 'EXPRESSION')
, WMS_PARAMETER_PVT.GETFLEXDATATYPECODE( WPVL.DATA_TYPE_CODE
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.USE_FOR_PUT_SORT_FLAG
, WPVL.USE_FOR_PUT_REST_FLAG
, WPVL.USE_FOR_PUT_QTYF_FLAG
, WPVL.USE_FOR_PICK_SORT_FLAG
, WPVL.USE_FOR_PICK_REST_FLAG
, WPVL.USE_FOR_PICK_QTYF_FLAG
, WPVL.USE_FOR_TT_ASSN_FLAG
, WPVL.USE_FOR_LABEL_REST_FLAG
, WPVL.USE_FOR_CG_REST_FLAG
, WPVL.USE_FOR_PICK_CONSIST_FLAG
, WPVL.USE_FOR_OP_SELECTION_FLAG
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, WMS_DB_OBJECTS WDO
WHERE WMS_PARAMETER_PVT.IFFLEXTHENAVAILABLE( WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME ) = 'Y'
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND WPVL.DB_OBJECT_ID = WDO.DB_OBJECT_ID (+)