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

Product:	PSP - Labor Distribution
Description:	PSPFV_ADJUSTMENT_APPROVERS displays information about the person who approves distribution adjustments.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PAC.ADJUSTMENT_BATCH_NAME
, PAC.APPROVER_ID
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PAC.REASON_FOR_ADJUSTMENT
, PAC.COMMENTS
, PAC.SET_OF_BOOKS_ID
, GL.NAME
, PAC.BUSINESS_GROUP_ID
, HR.NAME
, PAC.LAST_UPDATE_DATE
, PAC.LAST_UPDATED_BY
, PAC.CREATED_BY
, PAC.CREATION_DATE
FROM PSP_ADJUSTMENT_CONTROL_TABLE PAC
, PER_ALL_PEOPLE_F PPF
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HR
WHERE (PAC.APPROVER_ID=PPF.PERSON_ID
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PAC.BUSINESS_GROUP_ID=HR.ORGANIZATION_ID
AND PAC.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID WITH READ ONLY

Columns

Name
ADJUSTMENT_BATCH_NAME
APPROVER
FIRST_NAME
LAST_NAME
REASON_FOR_ADJUSTMENT
ADJUSTMENT_COMMENTS
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
BUSINESS_GROUP_ID
BUSINESS_GRP_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE