FND Design Data [Home] [Help]

View: PAY_BATCH_LINES_V

Product: PAY - Payroll
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.PAY_BATCH_LINES_V
View Text

SELECT DISTINCT ELEMENT_NAME
, ELEMENT_TYPE_ID
, PBL.BATCH_ID
, PBH.BATCH_STATUS
FROM PAY_BATCH_LINES PBL
, PAY_BATCH_HEADERS PBH
WHERE PBL.BATCH_ID = PBH.BATCH_ID

Columns

Name
ELEMENT_NAME
ELEMENT_TYPE_ID
BATCH_ID
BATCH_STATUS