VIEW: APPS.AS_TAP_LEADS_V

Source

View Text - Preformatted

SELECT /*+ parallel(A) parallel(SL) parallel(STATUS) */ SL.sales_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, SL.budget_amount, SL.source_promotion_id, UPPER(SL.currency_code), A.squal_char11, UPPER(SL.channel_code), STATUS.opp_open_status_flag from AS_STATUSES_B STATUS, AS_SALES_LEADS SL, JTF_TAE_1001_ACCOUNT_TRANS A WHERE SL.customer_id = A.trans_object_id and nvl(SL.address_id,010101) = nvl(A.trans_detail_object_id,010101) and nvl(SL.deleted_flag,'N') = 'N' and SL.status_code = STATUS.status_code and STATUS.lead_flag = 'Y'

View Text - HTML Formatted

SELECT /*+ PARALLEL(A) PARALLEL(SL) PARALLEL(STATUS) */ SL.SALES_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
, SL.BUDGET_AMOUNT
, SL.SOURCE_PROMOTION_ID
, UPPER(SL.CURRENCY_CODE)
, A.SQUAL_CHAR11
, UPPER(SL.CHANNEL_CODE)
, STATUS.OPP_OPEN_STATUS_FLAG
FROM AS_STATUSES_B STATUS
, AS_SALES_LEADS SL
, JTF_TAE_1001_ACCOUNT_TRANS A
WHERE SL.CUSTOMER_ID = A.TRANS_OBJECT_ID
AND NVL(SL.ADDRESS_ID
, 010101) = NVL(A.TRANS_DETAIL_OBJECT_ID
, 010101)
AND NVL(SL.DELETED_FLAG
, 'N') = 'N'
AND SL.STATUS_CODE = STATUS.STATUS_CODE
AND STATUS.LEAD_FLAG = 'Y'