VIEW: APPS.WMS_ACCESS_RULES_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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