View: AS_TAP_OPPORTUNITIES_V

Product:	AS - Sales Foundation
Description:	For TAP use
Implementation/DBA Data:	APPS.AS_TAP_OPPORTUNITIES_V

View Text

SELECT /*+ PARALLEL(A) PARALLEL(LEAD) */ LEAD.LEAD_ID
, A.TRANS_DETAIL_OBJECT_ID
, A.TRANS_OBJECT_ID
, A.SQUAL_CHAR08
, A.SQUAL_CHAR09
, A.SQUAL_CURC01
, A.SQUAL_CHAR02
, A.SQUAL_NUM06
, A.SQUAL_CHAR07
, A.SQUAL_CHAR03
, A.SQUAL_NUM01
, A.SQUAL_FC01
, A.SQUAL_CHAR01
, A.SQUAL_NUM05
, A.SQUAL_CHAR06
, A.SQUAL_CHAR05
, A.SQUAL_NUM03
, A.SQUAL_CHAR10
, A.SQUAL_CHAR04
, UPPER(LEAD.CHANNEL_CODE)
, LEAD.SOURCE_PROMOTION_ID
, UPPER(LEAD.STATUS)
, LEAD.TOTAL_AMOUNT
, UPPER(LEAD.CURRENCY_CODE)
, A.SQUAL_CHAR11
, STATUS.OPP_OPEN_STATUS_FLAG
FROM AS_LEADS_ALL LEAD
, JTF_TAE_1001_ACCOUNT_TRANS A
, AS_STATUSES_B STATUS
WHERE LEAD.CUSTOMER_ID = A.TRANS_OBJECT_ID AND NVL(LEAD.ADDRESS_ID
, 010101)=NVL(A.TRANS_DETAIL_OBJECT_ID
, 010101) AND LEAD.DELETED_FLAG = 'N'
AND LEAD.STATUS = STATUS.STATUS_CODE

Columns