1. Tables and Views for Procurement
  2. POZ_SUPP_ROLE_ASSIGNMENTS_V

POZ_SUPP_ROLE_ASSIGNMENTS_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

USER_ROLE_ID

USER_ID

ROLE_ID

ROLE_GUID

ACTIVE_FLAG

BUSINESS_GROUP_ID

CREATED_BY1

CREATION_DATE1

LAST_UPDATED_BY1

LAST_UPDATE_DATE1

LAST_UPDATE_LOGIN1

OBJECT_VERSION_NUMBER1

START_DATE

END_DATE

METHOD_CODE

TERMINATED_FLAG

AS ROLE_NAME

PROVISIONAL_ROLE_GUID

ALLOW_SUPP_PROV_FLAG

DEFAULT_FOR_POS_FLAG

DEFAULT_FOR_PON_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

UserRolePEO.USER_ROLE_ID AS USER_ROLE_ID,

UserRolePEO.USER_ID AS USER_ID,

UserRolePEO.ROLE_ID AS ROLE_ID,

UserRolePEO.ROLE_GUID AS ROLE_GUID,

UserRolePEO.ACTIVE_FLAG AS ACTIVE_FLAG,

UserRolePEO.BUSINESS_GROUP_ID AS BUSINESS_GROUP_ID,

UserRolePEO.CREATED_BY AS CREATED_BY1,

UserRolePEO.CREATION_DATE AS CREATION_DATE1,

UserRolePEO.LAST_UPDATED_BY AS LAST_UPDATED_BY1,

UserRolePEO.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1,

UserRolePEO.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN1,

UserRolePEO.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1,

UserRolePEO.START_DATE AS START_DATE,

UserRolePEO.END_DATE AS END_DATE,

UserRolePEO.METHOD_CODE AS METHOD_CODE,

UserRolePEO.TERMINATED_FLAG AS TERMINATED_FLAG,

RoleNamePEO.ROLE_NAME AS ROLE_NAME,

ProvisionableRolePEO.ROLE_GUID AS PROVISIONAL_ROLE_GUID,

ProvisionableRolePEO.ALLOW_SUPPLIER_PROVISION_FLAG AS ALLOW_SUPP_PROV_FLAG,

ProvisionableRolePEO.DEFAULT_FOR_POS_FLAG AS DEFAULT_FOR_POS_FLAG,

ProvisionableRolePEO.DEFAULT_FOR_PON_FLAG AS DEFAULT_FOR_PON_FLAG,

ProvisionableRolePEO.CREATED_BY AS CREATED_BY,

ProvisionableRolePEO.CREATION_DATE AS CREATION_DATE,

ProvisionableRolePEO.LAST_UPDATED_BY AS LAST_UPDATED_BY,

ProvisionableRolePEO.LAST_UPDATE_DATE AS LAST_UPDATE_DATE,

ProvisionableRolePEO.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN,

ProvisionableRolePEO.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER

FROM

PER_USER_ROLES UserRolePEO,

POZ_PROVISIONABLE_ROLES ProvisionableRolePEO,

PER_ROLES_DN_VL RoleNamePEO

WHERE

UserRolePEO.ROLE_GUID = ProvisionableRolePEO.ROLE_GUID AND

UserRolePEO.ROLE_ID = RoleNamePEO.ROLE_ID AND

ProvisionableRolePEO.ROLE_GUID IS NOT NULL AND

UserRolePEO.ACTIVE_FLAG='Y' AND

RoleNamePEO.ACTIVE_FLAG='Y'