[Home] [Help]
View: ASO_APR_JTF_SALES_APPROVERS_V
Product: | ASO - Order Capture |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT T1.GROUP_ID
, T1.GROUP_NAME
, T1.GROUP_DESC
, T1.START_DATE_ACTIVE
, T1.END_DATE_ACTIVE
, T2.ROLE_RELATE_ID
, T2.ROLE_RESOURCE_TYPE
, T2.START_DATE_ACTIVE
, T2.END_DATE_ACTIVE
, T3.ROLE_ID
, T3.ROLE_CODE
, T3.ROLE_TYPE_CODE
, T3.ROLE_NAME
, T3.ROLE_DESC
FROM JTF_RS_GROUPS_VL T1
, JTF_RS_ROLE_RELATIONS_VL T2
, JTF_RS_ROLES_VL T3
WHERE T2.ROLE_RESOURCE_TYPE = 'RS_GROUP'
AND T1.GROUP_ID = T2.ROLE_RESOURCE_ID
AND T2.ROLE_ID = T3.ROLE_ID
AND T3.ROLE_CODE = 'SALES_APPROVER'
Columns
Name |
JTF_RS_GROUP_ID |
JTF_RS_GROUP_NAME |
JTF_RS_GROUP_DESC |
JTF_RS_GROUP_START_DATE |
JTF_RS_GROUP_END_DATE |
JTF_RS_ROLE_RELATE_ID |
JTF_RS_ROLE_RESOURCE_TYPE |
JTF_RS_ROLE_RELAT_START_DATE |
JTF_RS_ROLE_RELAT_END_DATE |
JTF_RS_ROLE_ID |
JTF_RS_ROLE_CODE |
JTF_RS_ROLE_TYPE_CODE |
JTF_RS_ROLE_NAME |
JTF_RS_ROLE_DESC |