DBA Data[Home] [Help]

VIEW: APPS.AST_SALESREP_LOV_UWQ_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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