DBA Data[Home] [Help]

APPS.QPR_WKFL_UTIL dependencies on QPR_PN_PRICES

Line 325: from qpr_pn_prices

321: sum(decode(pn_pr_type_id, 4, unit_price, 0 )) pocmargin,
322: sum(decode(pn_pr_type_id, 2, percent_price, 0 )) invpriceperc,
323: sum(decode(pn_pr_type_id, 3, percent_price, 0 )) pocpriceperc,
324: sum(decode(pn_pr_type_id, 4, percent_price, 0 )) pocmarginperc
325: from qpr_pn_prices
326: where pn_line_id is not null
327: group by response_header_id, pn_line_id) pr,
328: (select response_header_id, pn_line_id,
329: sum(decode(erosion_type, 'ALL_COST', erosion_per_unit, 0 )) unit_cost,