Product: | WMS - Warehouse Management |
---|---|
Description: | WMS sort criteria view |
Implementation/DBA Data: | APPS.WMS_SORT_CRITERIA_V |
SELECT WSC.ROWID
, WSC.RULE_ID
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.ORGANIZATION_ID
, WRVL.USER_DEFINED_FLAG
, WRVL.TYPE_CODE
, MLR.MEANING
, MLR.DESCRIPTION
, WSC.SEQUENCE_NUMBER
, WSC.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
, WOVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WSC.ORDER_CODE
, ML.MEANING
, ML.DESCRIPTION
, WSC.CREATED_BY
, WSC.CREATION_DATE
, WSC.LAST_UPDATED_BY
, WSC.LAST_UPDATE_DATE
, WSC.LAST_UPDATE_LOGIN
, WSC.ATTRIBUTE1
, WSC.ATTRIBUTE2
, WSC.ATTRIBUTE3
, WSC.ATTRIBUTE4
, WSC.ATTRIBUTE5
, WSC.ATTRIBUTE6
, WSC.ATTRIBUTE7
, WSC.ATTRIBUTE8
, WSC.ATTRIBUTE9
, WSC.ATTRIBUTE10
, WSC.ATTRIBUTE11
, WSC.ATTRIBUTE12
, WSC.ATTRIBUTE13
, WSC.ATTRIBUTE14
, WSC.ATTRIBUTE15
, WSC.ATTRIBUTE_CATEGORY
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS MLR
, WMS_RULES_VL WRVL
, MFG_LOOKUPS ML
, WMS_SORT_CRITERIA WSC
WHERE ML.LOOKUP_TYPE = 'WMS_SORT_ORDER'
AND ML.LOOKUP_CODE = WSC.ORDER_CODE
AND WRVL.RULE_ID = WSC.RULE_ID
AND MLR.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND MLR.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WSC.PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID