VIEW: APPS.AS_TAP_OPPORTUNITIES_V

Source

View Text - Preformatted

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 nvl(LEAD.deleted_flag,'N') = 'N' and LEAD.status = STATUS.status_code

View Text - HTML Formatted

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 NVL(LEAD.DELETED_FLAG
, 'N') = 'N'
AND LEAD.STATUS = STATUS.STATUS_CODE