[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