DBA Data[Home] [Help]

VIEW: APPS.PAY_BATCH_LINES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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