VIEW: APPS.AR_CALL_ACTIONS_V

Source

View Text - Preformatted

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(+)))

View Text - HTML Formatted

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(+)))