FND Design Data [Home] [Help]

View: AR_APPROVAL_ACTION_HISTORY_V

Product: AR - Receivables
Description: (Release 10SC Only)
Implementation/DBA Data: ViewAPPS.AR_APPROVAL_ACTION_HISTORY_V
View Text

SELECT AAH.APPROVAL_ACTION_HISTORY_ID
, AAH.CREATED_BY
, AAH.ACTION_DATE
, AAH.ACTION_NAME
, AAH.ADJUSTMENT_ID
, AAH.COMMENTS
, AAH.ATTRIBUTE_CATEGORY
, AAH.ATTRIBUTE1
, AAH.ATTRIBUTE2
, AAH.ATTRIBUTE3
, AAH.ATTRIBUTE4
, AAH.ATTRIBUTE5
, AAH.ATTRIBUTE6
, AAH.ATTRIBUTE7
, AAH.ATTRIBUTE8
, AAH.ATTRIBUTE9
, AAH.ATTRIBUTE10
, AAH.ATTRIBUTE11
, AAH.ATTRIBUTE12
, AAH.ATTRIBUTE13
, AAH.ATTRIBUTE14
, AAH.ATTRIBUTE15
, AL1.MEANING
, FU.USER_NAME
FROM AR_APPROVAL_ACTION_HISTORY AAH
, AR_LOOKUPS AL1
, FND_USER FU
WHERE AL1.LOOKUP_TYPE(+) = 'APPROVAL_TYPE'
AND AAH.ACTION_NAME = AL1.LOOKUP_CODE(+)
AND FU.USER_ID(+) = AAH.CREATED_BY

Columns

Name
APPROVAL_ACTION_HISTORY_ID
CREATED_BY
ACTION_DATE
ACTION_NAME
ADJUSTMENT_ID
COMMENTS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ACTION_MEANING
CREATOR