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: PA_ASSET_ALLOC_EXCEPTIONS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ASSET_ALLOC_EXCEPTIONS_V

View Text

SELECT REQUEST_ID
, MODULE
, SUB_CONTEXT
, RECORD_TYPE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE20
, USER_ID
, ATTRIBUTE_DATE1
, ORG_ID
FROM PA_REPORTING_EXCEPTIONS
WHERE CONTEXT = 'PA_ASSET_ALLOCATION_PVT'
AND MODULE = 'ALLOCATE_UNASSIGNED'
AND ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID

Columns

Name
REQUEST_ID
MODULE
ASSET_OR_PROJECT_ERROR
RECORD_TYPE
PROJECT_ID
PROJECT_NUMBER
TASK_ID
PROJECT_ASSET_LINE_ID
CAPITAL_EVENT_ID
CAPITAL_EVENT_NUMBER
EVENT_NAME
ASSET_ALLOCATION_METHOD
PROJECT_ASSET_ID
ERROR_CODE
ERROR_MESSAGE
CREATED_BY
CREATION_DATE
ORG_ID