VIEW: APPS.WMS_PARAMETERS_VL

Source

View Text - Preformatted

SELECT wpb.PARAMETER_ID ,wpb.LAST_UPDATED_BY ,wpb.LAST_UPDATE_DATE ,wpb.CREATED_BY ,wpb.CREATION_DATE ,wpb.LAST_UPDATE_LOGIN ,wpb.OBJECT_ID ,wptl.NAME ,wptl.DESCRIPTION ,wpb.DB_OBJECT_REF_TYPE_CODE ,wpb.DB_OBJECT_ID ,wpb.DB_OBJECT_REFERENCE_ID ,wpb.PARAMETER_TYPE_CODE ,wpb.COLUMN_NAME ,wpb.EXPRESSION ,wpb.DATA_TYPE_CODE ,wpb.USE_FOR_PUT_SORT_FLAG ,wpb.USE_FOR_PUT_REST_FLAG ,wpb.USE_FOR_PUT_QTYF_FLAG ,wpb.USE_FOR_PICK_SORT_FLAG ,wpb.USE_FOR_PICK_REST_FLAG ,wpb.USE_FOR_PICK_QTYF_FLAG ,wpb.USE_FOR_TT_ASSN_FLAG ,wpb.USE_FOR_LABEL_REST_FLAG ,wpb.USE_FOR_CG_REST_FLAG ,wpb.USE_FOR_PICK_CONSIST_FLAG ,wpb.USER_DEFINED_FLAG ,wpb.FLEXFIELD_USAGE_CODE ,wpb.FLEXFIELD_APPLICATION_ID ,wpb.FLEXFIELD_NAME ,wpb.ATTRIBUTE_CATEGORY ,wpb.ATTRIBUTE1 ,wpb.ATTRIBUTE2 ,wpb.ATTRIBUTE3 ,wpb.ATTRIBUTE4 ,wpb.ATTRIBUTE5 ,wpb.ATTRIBUTE6 ,wpb.ATTRIBUTE7 ,wpb.ATTRIBUTE8 ,wpb.ATTRIBUTE9 ,wpb.ATTRIBUTE10 ,wpb.ATTRIBUTE11 ,wpb.ATTRIBUTE12 ,wpb.ATTRIBUTE13 ,wpb.ATTRIBUTE14 ,wpb.ATTRIBUTE15 ,wpb.rowid ,wpb.USE_FOR_OP_SELECTION_FLAG ,wpb.rule_subtype_code FROM WMS_PARAMETERS_TL wptl ,WMS_PARAMETERS_B wpb WHERE wptl.PARAMETER_ID = wpb.PARAMETER_ID AND wptl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT WPB.PARAMETER_ID
, WPB.LAST_UPDATED_BY
, WPB.LAST_UPDATE_DATE
, WPB.CREATED_BY
, WPB.CREATION_DATE
, WPB.LAST_UPDATE_LOGIN
, WPB.OBJECT_ID
, WPTL.NAME
, WPTL.DESCRIPTION
, WPB.DB_OBJECT_REF_TYPE_CODE
, WPB.DB_OBJECT_ID
, WPB.DB_OBJECT_REFERENCE_ID
, WPB.PARAMETER_TYPE_CODE
, WPB.COLUMN_NAME
, WPB.EXPRESSION
, WPB.DATA_TYPE_CODE
, WPB.USE_FOR_PUT_SORT_FLAG
, WPB.USE_FOR_PUT_REST_FLAG
, WPB.USE_FOR_PUT_QTYF_FLAG
, WPB.USE_FOR_PICK_SORT_FLAG
, WPB.USE_FOR_PICK_REST_FLAG
, WPB.USE_FOR_PICK_QTYF_FLAG
, WPB.USE_FOR_TT_ASSN_FLAG
, WPB.USE_FOR_LABEL_REST_FLAG
, WPB.USE_FOR_CG_REST_FLAG
, WPB.USE_FOR_PICK_CONSIST_FLAG
, WPB.USER_DEFINED_FLAG
, WPB.FLEXFIELD_USAGE_CODE
, WPB.FLEXFIELD_APPLICATION_ID
, WPB.FLEXFIELD_NAME
, WPB.ATTRIBUTE_CATEGORY
, WPB.ATTRIBUTE1
, WPB.ATTRIBUTE2
, WPB.ATTRIBUTE3
, WPB.ATTRIBUTE4
, WPB.ATTRIBUTE5
, WPB.ATTRIBUTE6
, WPB.ATTRIBUTE7
, WPB.ATTRIBUTE8
, WPB.ATTRIBUTE9
, WPB.ATTRIBUTE10
, WPB.ATTRIBUTE11
, WPB.ATTRIBUTE12
, WPB.ATTRIBUTE13
, WPB.ATTRIBUTE14
, WPB.ATTRIBUTE15
, WPB.ROWID
, WPB.USE_FOR_OP_SELECTION_FLAG
, WPB.RULE_SUBTYPE_CODE
FROM WMS_PARAMETERS_TL WPTL
, WMS_PARAMETERS_B WPB
WHERE WPTL.PARAMETER_ID = WPB.PARAMETER_ID
AND WPTL.LANGUAGE = USERENV('LANG')