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.

Skip to content FND Design Data

[Home] [Help]

View: AST_SALESREP_LOV_UWQ_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SALESREP_LOV_UWQ_V

View Text

SELECT ASV.IEU_LOV_COL1
, ASV.IEU_LOV_COL2
, ASV.IEU_LOV_COL3
, ASV.IEU_LOV_COL4
, ASV.SALES_GROUP_NAME
, ASV.SALES_GROUP_ID
, ASV.SALESREP_FULL_NAME
, ASV.SALESREP_LAST_NAME
, ASV.SALESREP_FIRST_NAME
, ASV.EMPLOYEE_PERSON_ID
, ASV.SALESFORCE_ID
, ASV.WORK_TELEPHONE
, ASV.EMAIL_ADDRESS
FROM AST_SALESREP_LOV_V ASV
WHERE 1=1 ORDER BY ASV.IEU_LOV_COL2

Columns

Name
IEU_LOV_COL1
IEU_LOV_COL2
IEU_LOV_COL3
IEU_LOV_COL4
SALES_GROUP_NAME
SALES_GROUP_ID
SALESREP_FULL_NAME
SALESREP_LAST_NAME
SALESREP_FIRST_NAME
EMPLOYEE_PERSON_ID
SALESFORCE_ID
WORK_TELEPHONE
EMAIL_ADDRESS