View: WMS_ACCESS_RULES_LOV_V

Product:	WMS - Warehouse Management
Description:	WMS accessable rules LOV view
Implementation/DBA Data:	APPS.WMS_ACCESS_RULES_LOV_V

View Text

SELECT WRV.RULE_ID
, WRV.LAST_UPDATED_BY
, WRV.LAST_UPDATE_DATE
, WRV.CREATED_BY
, WRV.CREATION_DATE
, WRV.LAST_UPDATE_LOGIN
, WRV.ORGANIZATION_ID
, '-1' ORGANIZATION_CODE
, WRV.TYPE_CODE
, WRV.NAME
, WRV.DESCRIPTION
, WRV.QTY_FUNCTION_PARAMETER_ID
, WRV.ENABLED_FLAG
, WRV.USER_DEFINED_FLAG
, WRV.ATTRIBUTE_CATEGORY
, WRV.ATTRIBUTE1
, WRV.ATTRIBUTE2
, WRV.ATTRIBUTE3
, WRV.ATTRIBUTE4
, WRV.ATTRIBUTE5
, WRV.ATTRIBUTE6
, WRV.ATTRIBUTE7
, WRV.ATTRIBUTE8
, WRV.ATTRIBUTE9
, WRV.ATTRIBUTE10
, WRV.ATTRIBUTE11
, WRV.ATTRIBUTE12
, WRV.ATTRIBUTE13
, WRV.ATTRIBUTE14
, WRV.ATTRIBUTE15
, -1 RESPONSIBILITY_ID
, WRV.MIN_PICK_TASKS_FLAG
FROM WMS_RULES_V WRV
WHERE WRV.ORGANIZATION_ID = -1 UNION SELECT WRV.RULE_ID
, WRV.LAST_UPDATED_BY
, WRV.LAST_UPDATE_DATE
, WRV.CREATED_BY
, WRV.CREATION_DATE
, WRV.LAST_UPDATE_LOGIN
, WRV.ORGANIZATION_ID
, OCV.ORGANIZATION_CODE
, WRV.TYPE_CODE
, WRV.NAME
, WRV.DESCRIPTION
, WRV.QTY_FUNCTION_PARAMETER_ID
, WRV.ENABLED_FLAG
, WRV.USER_DEFINED_FLAG
, WRV.ATTRIBUTE_CATEGORY
, WRV.ATTRIBUTE1
, WRV.ATTRIBUTE2
, WRV.ATTRIBUTE3
, WRV.ATTRIBUTE4
, WRV.ATTRIBUTE5
, WRV.ATTRIBUTE6
, WRV.ATTRIBUTE7
, WRV.ATTRIBUTE8
, WRV.ATTRIBUTE9
, WRV.ATTRIBUTE10
, WRV.ATTRIBUTE11
, WRV.ATTRIBUTE12
, WRV.ATTRIBUTE13
, WRV.ATTRIBUTE14
, WRV.ATTRIBUTE15
, OCV.RESPONSIBILITY_ID RESONSIBILITY_ID
, WRV.MIN_PICK_TASKS_FLAG
FROM WMS_RULES_V WRV
, ORG_ACCESS_VIEW OCV
WHERE WRV.ORGANIZATION_ID = OCV.ORGANIZATION_ID

Columns