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_DIST_LINE_ADJUST_BATCHES

Product:	PSP - Labor Distribution
Description:
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.SET_OF_BOOKS_ID
, GL.NAME
, PAC.BUSINESS_GROUP_ID
, HOU.NAME
, PAC.REASON_FOR_ADJUSTMENT
, PAC.COMMENTS
, 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 HOU
WHERE PAC.APPROVER_ID = PPF.PERSON_ID
AND (SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF. EFFECTIVE_END_DATE)
AND PAC.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PAC.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID WITH READ ONLY

Columns

Name
ADJUSTMENT_BATCH_NAME
APPROVER_ID
FIRST_NAME
LAST_NAME
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
BUSINESS_GROUP_ID
BUSINESS_GRP_NAME
REASON_FOR_ADJUSTMENT
COMMENTS_FOR_ADJUSTMENT
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE