View: AR_CUSTOMER_CALL_TOPICS_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_CUSTOMER_CALL_TOPICS_V

View Text

SELECT ALL CCT.ROWID
, CCT.CUSTOMER_CALL_TOPIC_ID
, CCT.LAST_UPDATED_BY
, CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATE_LOGIN
, CCT.CREATED_BY
, CCT.CREATION_DATE
, CCT.CUSTOMER_CALL_ID
, CCT.CUSTOMER_ID
, NVL(CCT.CUSTOMER_TRX_ID
, APS.CASH_RECEIPT_ID)
, RCT.CUSTOMER_TRX_ID
, APS.CASH_RECEIPT_ID
, DECODE(RCT.CUSTOMER_TRX_ID
, NULL
, APS.TRX_NUMBER
, RCT.TRX_NUMBER)
, RCT.TRX_NUMBER
, CCT.PAYMENT_SCHEDULE_ID
, DECODE(RCT.TRX_NUMBER
, NULL
, NULL
, APS.DUE_DATE)
, DECODE(RCT.TRX_NUMBER
, NULL
, 'REC'
, B.TYPE)
, CCT.REASON_CODE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CUSTOMER_RESPONSE_REASON'
, CCT.REASON_CODE)
, CCT.CALL_OUTCOME
, AL2.MEANING
, CCT.FOLLOW_UP_DATE
, CCT.FOLLOW_UP_ACTION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('FOLLOW_UP'
, CCT.FOLLOW_UP_ACTION)
, CCT.FOLLOW_UP_COMPANY_REP_ID
, DECODE(CCT.COMPLETE_FLAG
, NULL
, 'N'
, CCT.COMPLETE_FLAG)
, ANO.CUSTOMER_CALL_TOPIC_ID
, ANO.TEXT
, ROUND(TRUNC(SYSDATE)-APS.DUE_DATE
, 0)
, APS.INVOICE_CURRENCY_CODE
, APS.AMOUNT_DUE_REMAINING
, CCT.CUSTOMER_TRX_LINE_ID
, RCTL.LINE_NUMBER
, RCTL.DESCRIPTION
, RCTL.EXTENDED_AMOUNT
, CCT.PROMISE_DATE
, CCT.PROMISE_AMOUNT
, CCT.FORECAST_DATE
, CCT.COLLECTION_FORECAST
, CCT.COLLECTOR_ID
, ACO.NAME
, CCT.CALL_DATE
, CCT.SITE_USE_ID
, CCT.CONTACT_ID
, CCT.PHONE_ID
, CCT.ATTRIBUTE_CATEGORY
, CCT.ATTRIBUTE1
, CCT.ATTRIBUTE2
, CCT.ATTRIBUTE3
, CCT.ATTRIBUTE4
, CCT.ATTRIBUTE5
, CCT.ATTRIBUTE6
, CCT.ATTRIBUTE7
, CCT.ATTRIBUTE8
, CCT.ATTRIBUTE9
, CCT.ATTRIBUTE10
, CCT.ATTRIBUTE11
, CCT.ATTRIBUTE12
, CCT.ATTRIBUTE13
, CCT.ATTRIBUTE14
, CCT.ATTRIBUTE15
, APS.ATTRIBUTE_CATEGORY
, APS.ATTRIBUTE1
, APS.ATTRIBUTE2
, APS.ATTRIBUTE3
, APS.ATTRIBUTE4
, APS.ATTRIBUTE5
, APS.ATTRIBUTE6
, APS.ATTRIBUTE7
, APS.ATTRIBUTE8
, APS.ATTRIBUTE9
, APS.ATTRIBUTE10
, APS.ATTRIBUTE11
, APS.ATTRIBUTE12
, APS.ATTRIBUTE13
, APS.ATTRIBUTE14
, APS.ATTRIBUTE15
, DECODE(RCT.TRX_NUMBER
, NULL
, APS.TRX_NUMBER
, NULL)
, NULL
, /* APPLIED_AMOUNT */ NULL
, /* UNAPPLIED_AMOUNT */ NULL
, /* ON_ACCOUNT_AMOUNT */ NULL
, /* UNIDENTIFIED_AMOUNT */ NULL
, /* RECEIPT_DATE */ NULL
, /* METHOD */ NULL /* CURRENCY_CODE */
FROM AR_PAYMENT_SCHEDULES APS
, RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL
, RA_CUST_TRX_TYPES B
, AR_NOTES ANO
, AR_LOOKUPS AL2
, AR_COLLECTORS ACO
, AR_CUSTOMER_CALL_TOPICS CCT
WHERE ( AL2.LOOKUP_TYPE='CALL_OUTCOME' OR AL2.LOOKUP_TYPE IS NULL)
AND CCT.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID(+)
AND CCT.CUSTOMER_TRX_LINE_ID = RCTL.CUSTOMER_TRX_LINE_ID(+)
AND CCT.PAYMENT_SCHEDULE_ID = APS.PAYMENT_SCHEDULE_ID(+)
AND CCT.CUSTOMER_CALL_TOPIC_ID = ANO.CUSTOMER_CALL_TOPIC_ID(+)
AND CCT.CALL_OUTCOME = AL2.LOOKUP_CODE(+)
AND CCT.COLLECTOR_ID = ACO.COLLECTOR_ID(+)
AND RCT.CUST_TRX_TYPE_ID = B.CUST_TRX_TYPE_ID(+)

Columns