View: AR_CALL_ACTIONS_V

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

View Text

SELECT ALL ACA.ROWID
, ACA.CALL_ACTION_ID
, ACA.LAST_UPDATED_BY
, ACA.LAST_UPDATE_DATE
, ACA.LAST_UPDATE_LOGIN
, ACA.CREATED_BY
, ACA.ACTION_DATE
, ACA.CUSTOMER_CALL_ID
, ACA.CUSTOMER_CALL_TOPIC_ID
, ACA.ACTION_CODE
, AL1.MEANING
, ACA.ACTION_AMOUNT
, ANO.TEXT
, AAN.EMPLOYEE_ID
, FUS.USER_NAME
, ACA.COMPLETE_FLAG
, ACA.CREATION_DATE
FROM AR_ACTION_NOTIFICATIONS AAN
, AR_CALL_ACTIONS ACA
, AR_LOOKUPS AL1
, AR_NOTES ANO
, FND_USER FUS
WHERE AL1.LOOKUP_TYPE='ACTION'
AND ((ANO.CALL_ACTION_ID(+)=ACA.CALL_ACTION_ID)
AND (AAN.CALL_ACTION_ID(+)=ACA.CALL_ACTION_ID)
AND (ACA.ACTION_CODE=AL1.LOOKUP_CODE)
AND (AAN.EMPLOYEE_ID=FUS.USER_ID(+)))

Columns