Product: | WMS - Warehouse Management |
---|---|
Description: | WMS Rule Consistencies view |
Implementation/DBA Data: | APPS.WMS_RULE_CONSISTENCIES_V |
SELECT WRC.ROWID
, WRC.CONSISTENCY_ID
, WRC.RULE_ID
, WOVL.OBJECT_ID
, WOVL.NAME
, WRC.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 )
, WRC.LAST_UPDATED_BY
, WRC.LAST_UPDATE_DATE
, WRC.CREATED_BY
, WRC.CREATION_DATE
, WRC.LAST_UPDATE_LOGIN
, WRC.ATTRIBUTE_CATEGORY
, WRC.ATTRIBUTE1
, WRC.ATTRIBUTE2
, WRC.ATTRIBUTE3
, WRC.ATTRIBUTE4
, WRC.ATTRIBUTE5
, WRC.ATTRIBUTE6
, WRC.ATTRIBUTE7
, WRC.ATTRIBUTE8
, WRC.ATTRIBUTE9
, WRC.ATTRIBUTE10
, WRC.ATTRIBUTE11
, WRC.ATTRIBUTE12
, WRC.ATTRIBUTE13
, WRC.ATTRIBUTE14
, WRC.ATTRIBUTE15
FROM WMS_RULE_CONSISTENCIES WRC
, WMS_PARAMETERS_VL WPVL
, WMS_OBJECTS_VL WOVL
WHERE WPVL.PARAMETER_ID = WRC.PARAMETER_ID AND WOVL.OBJECT_ID = WPVL.OBJECT_ID