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: ASF_LEAD_SHARE_ERRORS_V

Product:	ASF - Sales Online
Description:	This View stores the errors occured during the Opportunity Exchnage cycle.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT LEAD.DESCRIPTION
, LEAD.LEAD_ID
, LE.ERROR_ID
, LE.PARTNER_ID
, LE.DIR_FLAG
, LE.ERROR_TYPE_ID
, LE.ERROR_CODE
, LE.ERROR_TEXT
, LE.ERROR_CRE_DATE
, PARTNER.PARTNER_NAME
FROM AS_LEADS_ALL LEAD
, ASF_PARTNER_PROFILE_V PARTNER
, AS_LS_ERRS LE
WHERE LEAD.LEAD_ID(+) = LE.LEAD_ID
AND LE.PARTNER_ID = PARTNER.PARTNER_ID

Columns

Name
DESCRIPTION
LEAD_ID
ERROR_ID
PARTNER_ID
DIR_FLAG
ERROR_TYPE_ID
ERROR_CODE
ERROR_TEXT
ERROR_CRE_DATE
PARTNER_NAME