Product: | WMS - Warehouse Management |
---|---|
Description: | WMS parameter MLS view |
Implementation/DBA Data: | APPS.WMS_PARAMETERS_VL |
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')