Product: | AS - Sales Foundation |
---|---|
Description: | To do lists view |
Implementation/DBA Data: | Not implemented in this database |
SELECT TL.ROWID
, TL.TODO_ID
, TL.LAST_UPDATE_DATE
, TL.LAST_UPDATED_BY
, TL.CREATION_DATE
, TL.CREATED_BY
, TL.LAST_UPDATE_LOGIN
, TL.DESCRIPTION
, TL.PERSONAL_FLAG
, TL.CLOSED_FLAG
, TL.ASSIGN_TO_PERSON_ID
, TL.ASSIGNED_BY_PERSON_ID
, TL.PRIORITY
, ASLKP1.MEANING
, TL.CUSTOMER_ID
, TL.ADDRESS_ID
, TL.CONTACT_ID
, TL.LEAD_ID
, TL.CLOSE_PERSON_ID
, TL.SALES_LEAD_ID
, TL.TODO_DATE
, TL.TODO_START_TIME
, TL.TODO_END_TIME
, TL.SCHD_ITEM_ID
, TL.ACTIVITY_TYPE
, TL.ACTIVITY_CODE
, ASLKP.MEANING
, TL.PROMOTION_ID
, TL.PHONE_ID
, TL.CATEGORY
, TL.ATTRIBUTE_CATEGORY
, TL.ATTRIBUTE1
, TL.ATTRIBUTE2
, TL.ATTRIBUTE3
, TL.ATTRIBUTE4
, TL.ATTRIBUTE5
, TL.ATTRIBUTE6
, TL.ATTRIBUTE7
, TL.ATTRIBUTE8
, TL.ATTRIBUTE9
, TL.ATTRIBUTE10
, TL.ATTRIBUTE11
, TL.ATTRIBUTE12
, TL.ATTRIBUTE13
, TL.ATTRIBUTE14
, TL.ATTRIBUTE15
, APER.FIRST_NAME
, APER.LAST_NAME
, APER.FIRST_NAME || ' ' || APER.LAST_NAME
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.STATUS
, TL.ADDRESS_ID
, ADDR.STATUS
, ADDR.CITY
, CONT.FIRST_NAME
, CONT.LAST_NAME
, CONT.FIRST_NAME || ' ' || CONT.LAST_NAME
, CONT.CONTACT_NUMBER
, CONT.STATUS
, ARLKP.MEANING
, PHON.AREA_CODE
, PHON.PHONE_NUMBER
, PHON.EXTENSION
, LEAD.LEAD_NUMBER
, LEAD.DESCRIPTION
, PROM.CODE
, PROM.NAME
, TL.STATUS_CODE
, ASLKP2.MEANING
, TL.NOTIFICATION_DAYS
, CONT.JOB_TITLE
, CONT.JOB_TITLE_CODE
FROM RA_PHONES PHON
, AS_LOOKUPS ASLKP
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AR_LOOKUPS ARLKP
, AS_OPPORTUNITIES LEAD
, RA_CONTACTS CONT
, RA_ADDRESSES ADDR
, RA_CUSTOMERS CUST
, AS_PROMOTIONS PROM
, PER_ALL_PEOPLE_F APER
, AS_TODO_LISTS TL
WHERE ARLKP.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE'
AND PHON.STATUS(+) = 'A'
AND PHON.PHONE_TYPE = ARLKP.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'TODO_PRIORITY'
AND TO_CHAR(TL.PRIORITY) = ASLKP1.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'TODO_STATUS'
AND TL.STATUS_CODE = ASLKP2.LOOKUP_CODE(+)
AND TL.PHONE_ID = PHON.PHONE_ID(+)
AND TL.LEAD_ID = LEAD.LEAD_ID(+)
AND TL.ADDRESS_ID = ADDR.ADDRESS_ID(+)
AND TL.CONTACT_ID = CONT.CONTACT_ID(+)
AND TL.CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND TRUNC(SYSDATE) BETWEEN APER.EFFECTIVE_START_DATE(+)
AND APER.EFFECTIVE_END_DATE(+)
AND ASLKP.LOOKUP_CODE(+) = TL.ACTIVITY_CODE
AND ASLKP.LOOKUP_TYPE(+) = TL.ACTIVITY_TYPE
AND TL.ASSIGN_TO_PERSON_ID = APER.PERSON_ID(+)
AND PROM.PROMOTION_ID(+) = TL.PROMOTION_ID