DBA Data[Home] [Help]

APPS.QPR_WKFL_UTIL dependencies on QPR_PN_PR_DETAILS

Line 335: from qpr_pn_pr_details

331: sum(decode(erosion_type, 'ALL_OFFINVOICE', erosion_per_unit, 0 )) unit_offinv,
332: sum(decode(erosion_type, 'ALL_COST', erosion_amount, 0 )) totcost,
333: sum(decode(erosion_type, 'ALL_ONINVOICE',erosion_amount, 0) ) totoninv,
334: sum(decode(erosion_type, 'ALL_OFFINVOICE', erosion_amount, 0 )) totoffinv
335: from qpr_pn_pr_details
336: where pn_line_id is not null
337: and erosion_type like 'ALL_%'
338: group by response_header_id, pn_line_id) pd
339: where l.response_header_id = pd.response_header_id