eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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