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

Product:	PAY - Payroll
Description:	View used to maintain batch header information for a PayMIX batch.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PBH.ROWID ROW_ID
, PBH.BATCH_TYPE BATCH_TYPE
, L1.MEANING BATCH_TYPE_DISP
, PBH.BATCH_ID BATCH_ID
, PBH.PAYROLL_ID PAYROLL_ID
, PP.PAYROLL_NAME PAYROLL_NAME_DISP
, PBH.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, L2.MEANING BATCH_STATUS_DISP
, PBH.BATCH_STATUS BATCH_STATUS
, PBH.REFERENCE_NUM REFERENCE_NUM
, PBH.LAST_PROCESSED_DATE LAST_PROCESSED_DATE
, PBH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PBH.LAST_UPDATED_BY LAST_UPDATED_BY
, PBH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PBH.CREATED_BY CREATED_BY
, PBH.CREATION_DATE CREATION_DATE
FROM HR_LOOKUPS L1
, HR_LOOKUPS L2
, FND_SESSIONS FS
, PAY_ALL_PAYROLLS_F PP
, PAY_PDT_BATCH_HEADERS PBH
WHERE PBH.PAYROLL_ID = PP.PAYROLL_ID
AND L1.LOOKUP_TYPE = 'PAY_PDT_BATCH_TYPES'
AND L1.LOOKUP_CODE = PBH.BATCH_TYPE
AND L2.LOOKUP_TYPE = 'PAY_PDT_BATCH_STATES'
AND L2.LOOKUP_CODE = PBH.BATCH_STATUS
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE

Columns

Name
ROW_ID
BATCH_TYPE
BATCH_TYPE_DISP
BATCH_ID
PAYROLL_ID
PAYROLL_NAME_DISP
BUSINESS_GROUP_ID
BATCH_STATUS_DISP
BATCH_STATUS
REFERENCE_NUM
LAST_PROCESSED_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE