Product: | AS - Sales Foundation |
---|---|
Description: | For TAP use |
Implementation/DBA Data: | APPS.AS_TAP_LEADS_V |
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
, 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 SL.DELETED_FLAG = 'N'
AND SL.STATUS_CODE = STATUS.STATUS_CODE
AND STATUS.LEAD_FLAG = 'Y'