eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OEFV_ORDER_APPROVALS

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT APPROVAL.ORDER_APPROVAL_ID
, APPROVAL.DATE_APPROVED
, APPROVAL.APPROVAL_COMMENT
, '_DF:OE:SO_ORDER_APPROVALS:APPROVAL'
, APPROVER.USER_NAME
, HEADER.ORDER_NUMBER
, ORDER_TYPE.NAME
, ACTION.NAME
, RESULT.NAME
, APPROVAL.APPROVER_ID
, APPROVAL.ACTION_ID
, APPROVAL.HEADER_ID
, APPROVAL.ORDER_TYPE_ID
, APPROVAL.RESULT_ID
, APPROVAL.LAST_UPDATE_DATE
, APPROVAL.LAST_UPDATED_BY
, APPROVAL.CREATION_DATE
, APPROVAL.CREATED_BY
FROM SO_ORDER_APPROVALS APPROVAL
, FND_USER APPROVER
, SO_ACTIONS ACTION
, SO_HEADERS_ALL HEADER
, SO_ORDER_TYPES_ALL ORDER_TYPE
, SO_RESULTS RESULT
WHERE APPROVAL.APPROVER_ID = APPROVER.USER_ID
AND APPROVAL.ACTION_ID = ACTION.ACTION_ID
AND APPROVAL.HEADER_ID = HEADER.HEADER_ID
AND APPROVAL.ORDER_TYPE_ID = ORDER_TYPE.ORDER_TYPE_ID
AND APPROVAL.RESULT_ID = RESULT.RESULT_ID WITH READ ONLY

Columns

Name
ORDER_APPROVAL_ID
APPROVAL_DATE
APPROVAL_COMMENT
"_DF"
APPROVER_NAME
ORDER_NUMBER
ORDER_TYPE_NAME
ACTION_NAME
RESULT_NAME
APPROVER_ID
ACTION_ID
HEADER_ID
ORDER_TYPE_ID
RESULT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY