DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on POR_VIEW_REQS_PKG

Line 6455: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(

6451: aname => 'FUNCTIONAL_CURRENCY');
6452:
6453: x_progress :='001';
6454: select nvl(sum(nvl(decode(pcr4.action_type, 'CANCELLATION', 0,
6455: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(
6456: prl.requisition_line_id)/prl.amount,
6457: nvl(pcr1.new_price, prl.unit_price)*
6458: nvl(pcr2.new_quantity, prl.quantity)*
6459: por_view_reqs_pkg.get_line_nonrec_tax_total(

Line 6459: por_view_reqs_pkg.get_line_nonrec_tax_total(

6455: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(
6456: prl.requisition_line_id)/prl.amount,
6457: nvl(pcr1.new_price, prl.unit_price)*
6458: nvl(pcr2.new_quantity, prl.quantity)*
6459: por_view_reqs_pkg.get_line_nonrec_tax_total(
6460: prl.requisition_line_id)/
6461: (prl.unit_price*prl.quantity)))),0)),0),
6462: nvl(sum(decode(pcr4.action_type, 'CANCELLATION', 0, decode(prl.matching_basis, 'AMOUNT', nvl(pcr3.new_amount, prl.amount),
6463: nvl(pcr1.new_price, prl.unit_price)*