APPS.PO_NOTIFICATION_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

select poh.org_id,poh.TYPE_LOOKUP_CODE,gls.currency_code
into l_org_id,lv_document_type,l_currency_code
from po_headers_all poh, financials_system_params_all fsp,
  gl_sets_of_books gls
where poh.segment1 = '6110'
and fsp.set_of_books_id = gls.set_of_books_id
AND fsp.org_id            = poh.org_id;

Line: 63

      SELECT sum( round (POD.nonrecoverable_tax *
                         decode(quantity_ordered,
                                NULL,
                                (nvl(POD.amount_ordered,0) - nvl(POD.amount_cancelled,0)) / decode (nvl(POD.amount_ordered, 1),0,1,nvl(POD.amount_ordered, 1) ),
                                (nvl(POD.quantity_ordered,0) - nvl(POD.quantity_cancelled,0)) / decode ( nvl(POD.quantity_ordered, 1),0,1,nvl(POD.quantity_ordered, 1) )
                               ) / X_min_acct_unit
                         ) * X_min_acct_unit
                )
      INTO l_tax_amt
      FROM po_lines pol,
           po_distributions pod
     WHERE pol.po_header_id = p_document_id
       AND pod.po_line_id = pol.po_line_id;

Line: 78

      SELECT sum( round (POD.nonrecoverable_tax *
                         decode(quantity_ordered,
                                NULL,
                                (nvl(POD.amount_ordered,0) - nvl(POD.amount_cancelled,0)) / decode ( nvl(POD.amount_ordered, 1),0,1,nvl(POD.amount_ordered, 1) ),
                                (nvl(POD.quantity_ordered,0) - nvl(POD.quantity_cancelled,0)) / decode (nvl(POD.quantity_ordered, 1),0,1,nvl(POD.quantity_ordered, 1) )
                               ),
                         X_precision
                        )
                )
      INTO l_tax_amt
      FROM po_lines pol,
           po_distributions pod
     WHERE pol.po_header_id = p_document_id
       AND pod.po_line_id = pol.po_line_id;