Product: | AR - Receivables |
---|---|
Description: | (Release 10SC Only) |
Implementation/DBA Data: | APPS.AR_APPROVAL_ACTION_HISTORY_V |
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