APPS.PO_DOCUMENT_TOTALS_PVT SQL Statements

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

Line: 218

    SELECT SUM(
           DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ))  -- Bug# 5378134
    INTO l_return_val
    FROM po_lines_merge_v pol --  Changed from po_lines_all
    WHERE pol.po_header_id = p_doc_level_id
          AND pol.draft_id = p_draft_id;

Line: 234

    SELECT SUM(
           DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
    INTO l_return_val
    FROM po_lines_archive_all pol
    WHERE pol.po_header_id = p_doc_level_id
    AND (  (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POL.revision_num =
              (SELECT max(POL2.revision_num)
               FROM po_lines_archive_all pol2
               WHERE pol2.po_line_id = pol.po_line_id
               AND pol2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 270

    SELECT DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
    INTO l_return_val
    FROM po_lines_merge_v pol --  Changed from po_lines_all
    WHERE pol.po_line_id = p_doc_level_id
          AND pol.draft_id = p_draft_id;

Line: 285

    SELECT DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
    INTO l_return_val
    FROM po_lines_archive_all pol
    WHERE pol.po_line_id = p_doc_level_id
    AND (  (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POL.revision_num =
              (SELECT max(POL2.revision_num)
               FROM po_lines_archive_all pol2
               WHERE pol2.po_line_id = pol.po_line_id
               AND pol2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 320

    SELECT DECODE(POLL.matching_basis
                  , 'AMOUNT', poll.amount - nvl(poll.amount_cancelled,0)
                  , --QUANTITY
                    nvl2(l_mau
                        , round((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override/l_mau) * l_mau
                        , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override),l_precision) )) -- Bug# 5378134
    INTO l_return_val
    FROM po_line_locations_merge_v poll --  Changed from po_line_locations_all
    WHERE poll.line_location_id = p_doc_level_id
          AND poll.draft_id = p_draft_id;

Line: 337

    SELECT DECODE(POLL.matching_basis
                  , 'AMOUNT', poll.amount - nvl(poll.amount_cancelled,0)
                  , --QUANTITY
                    nvl2(l_mau
                        , round((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override/l_mau) * l_mau
                        , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override),l_precision) )) -- Bug# 5378134
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.line_location_id = p_doc_level_id
    AND (  (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POLL.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 374

    SELECT DECODE(POLL.matching_basis
                  , 'AMOUNT', pod.amount_ordered - nvl(pod.amount_cancelled,0)
                  , --QUANTITY
                    nvl2(l_mau
                        , round((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
                                *poll.price_override/l_mau) * l_mau
                        , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
                                *poll.price_override),l_precision) )) -- Bug# 5378134
    INTO l_return_val
    FROM po_line_locations_merge_v poll --  Changed from po_line_locations_all
       , po_distributions_merge_v pod --  Changed from po_distributions_all
    WHERE pod.po_distribution_id = p_doc_level_id
          AND poll.line_location_id = pod.line_location_id
          AND poll.draft_id = pod.draft_id
          AND poll.draft_id = p_draft_id;

Line: 394

    SELECT DECODE(POLL.matching_basis
                  , 'AMOUNT', pod.amount_ordered - nvl(pod.amount_cancelled,0)
                  , --QUANTITY
                    nvl2(l_mau
                        , round((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
                                *poll.price_override/l_mau) * l_mau
                        , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
                                *poll.price_override),l_precision) )) -- Bug# 5378134
    INTO l_return_val
    FROM po_line_locations_archive_all poll
       , po_distributions_archive_all pod
    WHERE pod.po_distribution_id = p_doc_level_id
    AND poll.line_location_id = pod.line_location_id
    AND (  (p_doc_revision_num IS NULL
            AND pod.latest_external_flag = 'Y'
            AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POD.revision_num =
              (SELECT max(POD2.revision_num)
               FROM po_distributions_archive_all pod2
               WHERE pod2.po_distribution_id = pod.po_distribution_id
               AND pod2.revision_num <= p_doc_revision_num)
            AND POLL.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 537

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', poll.amount_received
                  , --QUANTITY
                    nvl2(l_mau
                        , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
                        , round((poll.quantity_received*poll.price_override),l_precision)) ))   --Bug5391045
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_line_id
    AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE')                --Bug5391045
    ;

Line: 562

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', poll.amount_received
                  , --QUANTITY
                    nvl2(l_mau
                        , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
                        , round((poll.quantity_received*poll.price_override),l_precision)) ))     --Bug5391045
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_line_id = p_line_id
    AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE')             --Bug5391045
    AND (  (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 690

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', poll.amount_received
                  , --QUANTITY
                    nvl2(l_mau
                        , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
                        , round((poll.quantity_received*poll.price_override),l_precision)) ))    --Bug5391045
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_header_id = p_header_id
    AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE')            --Bug5391045
    ;

Line: 715

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', poll.amount_received
                  , --QUANTITY
                    nvl2(l_mau
                        , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
                        , round((poll.quantity_received*poll.price_override),l_precision)) ))    --Bug5391045
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_header_id = p_header_id
    AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE')          --Bug5391045
    AND (  (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 846

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', pod.amount_delivered
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
                        , round((pod.quantity_delivered*poll.price_override),l_precision)) ))   --Bug5391045
    INTO l_return_val
    FROM po_line_locations_all poll
       , po_distributions_all pod
    WHERE poll.po_line_id = p_line_id
    AND pod.line_location_id = poll.line_location_id
    AND pod.distribution_type = 'STANDARD'
    ;

Line: 873

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', pod.amount_delivered
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
                        , round((pod.quantity_delivered*poll.price_override),l_precision)) ))   --Bug5391045
    INTO l_return_val
    FROM po_line_locations_archive_all poll
       , po_distributions_archive_all pod
    WHERE poll.po_line_id = p_line_id
    AND pod.line_location_id = poll.line_location_id
    AND pod.distribution_type = 'STANDARD'
    AND (  (p_doc_revision_num IS NULL
            AND poll.latest_external_flag = 'Y'
            AND pod.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            AND pod.revision_num =
              (SELECT max(POD2.revision_num)
               FROM po_distributions_archive_all pod2
               WHERE pod2.po_distribution_id = pod.po_distribution_id
               AND pod2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1013

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', pod.amount_delivered
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
                        , round((pod.quantity_delivered*poll.price_override),l_precision)) ))    --Bug5391045
    INTO l_return_val
    FROM po_line_locations_all poll
       , po_distributions_all pod
    WHERE poll.po_header_id = p_header_id
    AND pod.line_location_id = poll.line_location_id
    AND pod.distribution_type = 'STANDARD'
    ;

Line: 1040

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', pod.amount_delivered
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
                        , round((pod.quantity_delivered*poll.price_override),l_precision)) ))   --Bug5391045
    INTO l_return_val
    FROM po_line_locations_archive_all poll
       , po_distributions_archive_all pod
    WHERE poll.po_header_id = p_header_id
    AND pod.line_location_id = poll.line_location_id
    AND pod.distribution_type = 'STANDARD'
    AND (  (p_doc_revision_num IS NULL
            AND poll.latest_external_flag = 'Y'
            AND pod.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            AND pod.revision_num =
              (SELECT max(POD2.revision_num)
               FROM po_distributions_archive_all pod2
               WHERE pod2.po_distribution_id = pod.po_distribution_id
               AND pod2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1160

  SELECT pol.org_id
  INTO l_org_id
  FROM po_lines_all pol
  WHERE pol.po_line_id = p_line_id;

Line: 1177

    SELECT SUM(nvl(amount_billed,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type = 'STANDARD'
    ;

Line: 1196

    SELECT SUM(nvl(amount_billed,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type='STANDARD'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1301

  SELECT poh.org_id
  INTO l_org_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_header_id
  ;

Line: 1319

    SELECT SUM(nvl(amount_billed,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type = 'STANDARD'
    ;

Line: 1338

    SELECT SUM(nvl(amount_billed,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type='STANDARD'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1443

  SELECT pol.org_id
  INTO l_org_id
  FROM po_lines_all pol
  WHERE pol.po_line_id = p_line_id;

Line: 1460

    SELECT SUM(nvl(amount_financed,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type = 'PREPAYMENT'
    ;

Line: 1479

    SELECT SUM(nvl(amount_financed,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type='PREPAYMENT'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1584

  SELECT poh.org_id
  INTO l_org_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_header_id
  ;

Line: 1602

    SELECT SUM(nvl(amount_financed,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type = 'PREPAYMENT'
    ;

Line: 1621

    SELECT SUM(nvl(amount_financed,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type='PREPAYMENT'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1723

  SELECT pol.org_id
  INTO l_org_id
  FROM po_lines_all pol
  WHERE pol.po_line_id = p_line_id;

Line: 1740

    SELECT SUM(nvl(amount_recouped,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type = 'PREPAYMENT'
    ;

Line: 1759

    SELECT SUM(nvl(amount_recouped,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type='PREPAYMENT'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 1861

  SELECT poh.org_id
  INTO l_org_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_header_id
  ;

Line: 1879

    SELECT SUM(nvl(amount_recouped,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type = 'PREPAYMENT'
    ;

Line: 1898

    SELECT SUM(nvl(amount_recouped,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type='PREPAYMENT'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 2001

  SELECT pol.org_id
  INTO l_org_id
  FROM po_lines_all pol
  WHERE pol.po_line_id = p_line_id;

Line: 2018

    SELECT SUM(nvl(retainage_withheld_amount,0)
               - nvl(retainage_released_amount,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type = 'STANDARD'
    ;

Line: 2038

    SELECT SUM(nvl(retainage_withheld_amount,0)
               - nvl(retainage_released_amount,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_line_id = p_line_id
    AND poll.shipment_type='STANDARD'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 2142

  SELECT poh.org_id
  INTO l_org_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_header_id
  ;

Line: 2160

    SELECT SUM(nvl(retainage_withheld_amount,0)
               - nvl(retainage_released_amount,0))
    INTO l_return_val
    FROM po_line_locations_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type = 'STANDARD'
    ;

Line: 2180

    SELECT SUM(nvl(retainage_withheld_amount,0)
               - nvl(retainage_released_amount,0))
    INTO l_return_val
    FROM po_line_locations_archive_all poll
    WHERE poll.po_header_id = p_header_id
    AND poll.shipment_type='STANDARD'
    AND (  (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND poll.revision_num =
              (SELECT max(POLL2.revision_num)
               FROM po_line_locations_archive_all poll2
               WHERE poll2.line_location_id = poll.line_location_id
               AND poll2.revision_num <= p_doc_revision_num)
            )
        )
    ;

Line: 2273

  SELECT pol.po_header_id
  INTO l_header_id
  FROM po_lines_merge_v pol --  Changed from po_lines_all
  WHERE pol.po_line_id = p_line_id
        AND pol.draft_id = p_draft_id;

Line: 2293

    SELECT SUM(poll.quantity)
    INTO l_return_val
    FROM po_line_locations_merge_v poll --  Changed from po_line_locations_all
    WHERE poll.po_line_id = p_line_id
          AND poll.draft_id = p_draft_id
          AND poll.shipment_type = 'STANDARD';

Line: 2314

  SELECT nvl(pol.quantity, 0)
  INTO l_return_val
  FROM po_lines_merge_v pol --  Changed from po_lines_all
  WHERE pol.po_line_id = p_line_id
        AND pol.draft_id = p_draft_id;

Line: 2396

    SELECT SUM(
           DECODE(poll.matching_basis
                  , 'AMOUNT', poll.amount-nvl(poll.amount_cancelled,0)
                  , --QUANTITY
                    nvl2(l_mau
                        , round((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override/l_mau) * l_mau
                        , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
                                *poll.price_override),l_precision) ) ))             --Bug5391045
    INTO l_return_val
    FROM po_line_locations_merge_v poll --  Changed from po_line_locations_all
    WHERE poll.po_line_id = p_line_id
          AND poll.draft_id = p_draft_id
          AND poll.shipment_type = 'STANDARD'
    ;

Line: 2477

    SELECT SUM(pod.quantity_ordered)
    INTO l_return_val
    FROM po_distributions_merge_v pod --  Changed from po_distributions_all
    WHERE pod.line_location_id = p_line_loc_id
          AND pod.draft_id = p_draft_id;

Line: 2548

    SELECT SUM(pod.amount_ordered)
    INTO l_return_val
    FROM po_distributions_merge_v pod --  Changed from po_distributions_all
    WHERE pod.line_location_id = p_line_loc_id
          AND pod.draft_id = p_draft_id;

Line: 2642

  SELECT nvl2(l_mau
              , round((l_amount_ordered + nvl(nonrecoverable_tax,0))
	               * nvl(rate,1)/l_mau) * l_mau
	      , round((l_amount_ordered + nvl(nonrecoverable_tax,0)) * nvl(rate,1), l_precision))
  INTO l_return_val
  FROM po_distributions_all
  WHERE po_distribution_id = p_distribution_id;

Line: 2741

	SELECT Min(pol.po_header_id)
    INTO l_header_id
    FROM po_lines_merge_v pol
    WHERE pol.po_line_id = p_doc_level_id;

Line: 2749

    SELECT Min(poll.po_header_id)
    INTO l_header_id
    FROM po_line_locations_merge_v poll
    WHERE poll.line_location_id = p_doc_level_id;

Line: 2757

    SELECT Min(pod.po_header_id)
    INTO l_header_id
    FROM po_distributions_merge_v pod
    WHERE pod.po_distribution_id = p_doc_level_id;

Line: 2769

  SELECT poh.currency_code, poh.org_id
  INTO l_po_currency, l_org_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = l_header_id
  ;

Line: 3511

SELECT PO_DOCUMENT_TOTALS_GT_S.nextval INTO l_temp_table_key from dual;

Line: 3536

  INSERT INTO PO_DOCUMENT_TOTALS_GT
  (
    key,
    line_location_id,
    amount_based_flag,
    shipment_type,
    payment_type,
    price,
    quantity_total,
    quantity_billed,
    quantity_delivered,
    quantity_financed,
    quantity_recouped,
    quantity_received,
    quantity_shipped,
    amount_total,
    amount_billed,
    amount_delivered,
    amount_financed,
    amount_recouped,
    amount_received,
    amount_shipped,
    retainage_withheld_amount,
    retainage_released_amount
  )
  SELECT
    l_temp_table_key,
    POLL.line_location_id,
    DECODE(POLL.value_basis,
          'FIXED PRICE', 'Y',
          'RATE', 'Y',
          'N') amount_based_flag,
    POLL.shipment_type,
    POLL.payment_type,
    POLL.price_override,
    SUM( (nvl(POD.quantity_ordered,0) - nvl(POD.quantity_cancelled,0)) ),
    SUM( nvl(POD.quantity_billed,0) ),
    SUM( nvl(POD.quantity_delivered,0) ),
    SUM( nvl(POD.quantity_financed,0) ),
    SUM( nvl(POD.quantity_recouped,0) ),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.quantity_received),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.quantity_shipped),
    SUM( (nvl(POD.amount_ordered,0) - nvl(POD.amount_cancelled,0)) ),
    SUM( nvl(POD.amount_billed,0) ),
    SUM( nvl(POD.amount_delivered,0) ),
    SUM( nvl(POD.amount_financed,0) ),
    SUM( nvl(POD.amount_recouped,0) ),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_received),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_shipped),
    SUM( nvl(POD.retainage_withheld_amount,0) ),
    SUM( nvl(POD.retainage_released_amount,0) )
  FROM
    PO_LINE_LOCATIONS_ALL POLL,
    PO_DISTRIBUTIONS_ALL POD
  WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
  AND POD.line_location_id = POLL.line_location_id
  GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,
  POLL.payment_type, POLL.price_override, POLL.quantity_received, POLL.quantity_shipped,
  POLL.amount_received, POLL.amount_shipped
  ;

Line: 3601

    PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);

Line: 3629

  INSERT INTO PO_DOCUMENT_TOTALS_GT
  (
    key,
    line_location_id,
    amount_based_flag,
    shipment_type,
    payment_type,
    price,
    quantity_total,
    quantity_billed,
    quantity_delivered,
    quantity_financed,
    quantity_recouped,
    quantity_received,
    quantity_shipped,
    amount_total,
    amount_billed,
    amount_delivered,
    amount_financed,
    amount_recouped,
    amount_received,
    amount_shipped,
    retainage_withheld_amount,
    retainage_released_amount
  )
  SELECT
    l_temp_table_key,
    POLL.line_location_id,
    DECODE(POLL.value_basis,
          'FIXED PRICE', 'Y',
          'RATE', 'Y',
          'N') amount_based_flag,
    POLL.shipment_type,
    POLL.payment_type,
    POLL.price_override,
    SUM( (nvl(POD.quantity_ordered,0) - nvl(POD.quantity_cancelled,0)) ),
    SUM( nvl(POD.quantity_billed,0) ),
    SUM( nvl(POD.quantity_delivered,0) ),
    SUM( nvl(POD.quantity_financed,0) ),
    SUM( nvl(POD.quantity_recouped,0) ),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.quantity_received),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.quantity_shipped),
    SUM( (nvl(POD.amount_ordered,0) - nvl(POD.amount_cancelled,0)) ),
    SUM( nvl(POD.amount_billed,0) ),
    SUM( nvl(POD.amount_delivered,0) ),
    SUM( nvl(POD.amount_financed,0) ),
    SUM( nvl(POD.amount_recouped,0) ),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_received),
    DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_shipped),
    SUM( nvl(POD.retainage_withheld_amount,0) ),
    SUM( nvl(POD.retainage_released_amount,0) )
  FROM
    PO_LINE_LOCATIONS_ARCHIVE_ALL POLL,
    PO_DISTRIBUTIONS_ARCHIVE_ALL POD
  WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
  AND POD.revision_num = l_distribution_rev_num_tbl(i)
  AND POD.line_location_id = POLL.line_location_id
  AND (  (p_doc_revision_num IS NULL AND POLL.latest_external_flag = 'Y')
      OR (p_doc_revision_num IS NOT NULL
          AND POLL.revision_num =
             (SELECT max(POLL2.revision_num)
              FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLL2
              WHERE POLL2.line_location_id = POLL.line_location_id
              AND POLL2.revision_num <= p_doc_revision_num)
          )
      )
  GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,
    POLL.payment_type, POLL.price_override, POLL.quantity_received,
    POLL.quantity_shipped, POLL.amount_received, POLL.amount_shipped
  ;

Line: 3704

    PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);

Line: 3797

  UPDATE PO_DOCUMENT_TOTALS_GT GTT
  SET
    GTT.amount_total = (GTT.quantity_total * GTT.price)
  , GTT.amount_billed = (GTT.quantity_billed * GTT.price)
  , GTT.amount_delivered = (GTT.quantity_delivered * GTT.price)
  , GTT.amount_financed = (GTT.quantity_financed * GTT.price)
  , GTT.amount_recouped = (GTT.quantity_recouped * GTT.price)
  , GTT.amount_received = (GTT.quantity_received * GTT.price)
  , GTT.amount_shipped  = (GTT.quantity_shipped * GTT.price)
  WHERE amount_based_flag = 'N'
  ;

Line: 3813

  UPDATE PO_DOCUMENT_TOTALS_GT GTT
  SET
    GTT.amount_total = nvl2(l_mau
                           , round(amount_total/l_mau) * l_mau
                           , round(amount_total, l_precision))
  , GTT.amount_billed = nvl2(l_mau
                            , round(amount_billed/l_mau) * l_mau
                            , round(amount_billed, l_precision))
  , GTT.amount_delivered = nvl2(l_mau
                               , round(amount_delivered/l_mau) * l_mau
                               , round(amount_delivered, l_precision))
  , GTT.amount_financed = nvl2(l_mau
                              , round(amount_financed/l_mau) * l_mau
                              , round(amount_financed, l_precision))
  , GTT.amount_recouped = nvl2(l_mau
                              , round(amount_recouped/l_mau) * l_mau
                              , round(amount_recouped, l_precision))
  , GTT.amount_received = nvl2(l_mau
                              , round(amount_received/l_mau) * l_mau
                              , round(amount_received, l_precision))
  , GTT.amount_shipped = nvl2(l_mau
                             , round(amount_shipped/l_mau) * l_mau
                             , round(amount_shipped, l_precision))
  WHERE GTT.amount_based_flag = 'N'
  ;

Line: 3842

    PO_LOG.stmt(d_mod,d_position,'Updated amts - rowcount:',SQL%ROWCOUNT);

Line: 4000

  SELECT
    SUM(CASE WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
             THEN amount_total ELSE 0 END) amount_total_actuals,
    SUM(CASE WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
             THEN amount_total ELSE 0 END) amount_total_financing,
    SUM(CASE WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
             THEN amount_delivered ELSE 0 END) amount_delivered_actuals,
    SUM(CASE WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
             THEN amount_delivered ELSE 0 END) amount_delivered_financing,
    SUM(CASE WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
             THEN amount_received ELSE 0 END) amount_received_actuals,
    SUM(CASE WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
             THEN amount_received ELSE 0 END) amount_received_financing,
    SUM(CASE WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
             THEN amount_shipped ELSE 0 END) amount_shipped_actuals,
    SUM(CASE WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
             THEN amount_shipped ELSE 0 END) amount_shipped_financing,
    SUM(amount_billed),
    SUM(amount_financed),
    SUM(amount_recouped),
    SUM(retainage_withheld_amount),
    SUM(retainage_released_amount)
  INTO
    l_amount_total_actuals,
    l_amount_total_financing,
    l_amount_delivered_actuals,
    l_amount_delivered_financing,
    l_amount_received_actuals,
    l_amount_received_financing,
    l_amount_shipped_actuals,
    l_amount_shipped_financing,
    l_amount_billed,
    l_amount_financed,
    l_amount_recouped,
    l_retainage_withheld_amount,
    l_retainage_released_amount
  FROM PO_DOCUMENT_TOTALS_GT GTT
  WHERE key = p_temp_table_key
  ;

Line: 4055

    SELECT
      SUM(quantity_total),
      SUM(quantity_delivered),
      SUM(quantity_received),
      SUM(quantity_shipped),
      SUM(quantity_billed),
      SUM(quantity_financed),
      SUM(quantity_recouped)
    INTO
      l_quantity_total_actuals,
      l_quantity_delivered_actuals,
      l_quantity_received_actuals,
      l_quantity_shipped_actuals,
      l_quantity_billed,
      l_quantity_financed,
      l_quantity_recouped
    FROM PO_DOCUMENT_TOTALS_GT GTT
    WHERE GTT.key = p_temp_table_key
    AND GTT.amount_based_flag = 'N'
    AND nvl(GTT.payment_type, 'NULL') <> C_payment_type_RATE
    ;

Line: 4090

    SELECT
      MAX(GTTSUM.qty_total_actuals),
      MAX(GTTSUM.qty_total_financing),
      MAX(GTTSUM.qty_delivered_actuals),
      MAX(GTTSUM.qty_delivered_financing),
      MAX(GTTSUM.qty_received_actuals),
      MAX(GTTSUM.qty_received_financing),
      MAX(GTTSUM.qty_shipped_actuals),
      MAX(GTTSUM.qty_shipped_financing),
      MAX(GTTSUM.qty_billed),
      MAX(GTTSUM.qty_financed),
      MAX(GTTSUM.qty_recouped)
    INTO
      l_quantity_total_actuals,
      l_quantity_total_financing,
      l_quantity_delivered_actuals,
      l_quantity_delivered_financing,
      l_quantity_received_actuals,
      l_quantity_received_financing,
      l_quantity_shipped_actuals,
      l_quantity_shipped_financing,
      l_quantity_billed,
      l_quantity_financed,
      l_quantity_recouped
    FROM
    ( SELECT
        GTT.line_location_id,
        SUM(CASE
              WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
              THEN GTT.quantity_total ELSE 0 END) qty_total_actuals,
        SUM(CASE
              WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
              THEN GTT.quantity_total ELSE 0 END) qty_total_financing,
        SUM(CASE
              WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
              THEN GTT.quantity_delivered ELSE 0 END) qty_delivered_actuals,
        SUM(CASE
              WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
              THEN GTT.quantity_delivered ELSE 0 END) qty_delivered_financing,
        SUM(CASE
              WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
              THEN GTT.quantity_received ELSE 0 END) qty_received_actuals,
        SUM(CASE
              WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
              THEN GTT.quantity_received ELSE 0 END) qty_received_financing,
        SUM(CASE
              WHEN GTT.shipment_type <> C_ship_type_PREPAYMENT
              THEN GTT.quantity_shipped ELSE 0 END) qty_shipped_actuals,
        SUM(CASE
              WHEN GTT.shipment_type = C_ship_type_PREPAYMENT
              THEN GTT.quantity_shipped ELSE 0 END) qty_shipped_financing,
        SUM(GTT.quantity_billed) qty_billed,
        SUM(GTT.quantity_financed) qty_financed,
        SUM(GTT.quantity_recouped) qty_recouped
      FROM PO_DOCUMENT_TOTALS_GT GTT
      WHERE GTT.key = p_temp_table_key
      AND GTT.amount_based_flag = 'N'
      AND nvl(GTT.payment_type, 'NULL') = C_payment_type_MILESTONE
      GROUP BY GTT.line_location_id
    ) GTTSUM
    ;

Line: 4269

  DELETE FROM PO_DOCUMENT_TOTALS_GT
  WHERE key = p_temp_table_key
  ;

Line: 4275

    PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);

Line: 4371

    SELECT SUM(
           DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ))
    INTO l_return_val
    FROM po_lines_merge_v pol --  Changed from po_lines_all
    WHERE pol.po_header_id = p_doc_level_id
          AND pol.draft_id = p_draft_id
          AND (NVL(pol.clm_option_indicator,'N') <> 'O'
               OR pol.clm_exercised_flag = 'Y'); -- 

Line: 4389

    SELECT SUM(
           DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ))
    INTO l_return_val
    FROM po_lines_archive_all pol
    WHERE pol.po_header_id = p_doc_level_id
    AND (  (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POL.revision_num =
              (SELECT max(POL2.revision_num)
               FROM po_lines_archive_all pol2
               WHERE pol2.po_line_id = pol.po_line_id
               AND pol2.revision_num <= p_doc_revision_num)
            )
        )
    AND NVL(pol.CLM_OPTION_INDICATOR,'N') <> 'O';

Line: 4425

    SELECT DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) )
    INTO l_return_val
    FROM po_lines_merge_v pol --  Changed from po_lines_all
    WHERE pol.po_line_id = p_doc_level_id
          AND pol.draft_id = p_draft_id
          AND (NVL(pol.clm_option_indicator,'N') <> 'O'
               OR pol.clm_exercised_flag = 'Y'); -- 

Line: 4442

    SELECT DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) )
    INTO l_return_val
    FROM po_lines_archive_all pol
    WHERE pol.po_line_id = p_doc_level_id
    AND (  (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
        OR (p_doc_revision_num IS NOT NULL
            AND POL.revision_num =
              (SELECT max(POL2.revision_num)
               FROM po_lines_archive_all pol2
               WHERE pol2.po_line_id = pol.po_line_id
               AND pol2.revision_num <= p_doc_revision_num)
            )
        )
    AND NVL(pol.CLM_OPTION_INDICATOR,'N') <> 'O';

Line: 4557

    SELECT Sum(DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ))
    INTO l_return_val
    FROM po_lines_merge_v pol
    WHERE pol.po_header_id = p_doc_id
          AND pol.draft_id = p_draft_id
          AND pol.clm_exhibit_name = p_exhibit_name;

Line: 4574

    SELECT SUM(
            DECODE(POL.matching_basis
                  , 'AMOUNT', pol.amount
                  , --QUANTITY
                    nvl2(l_mau
                        , round(pol.quantity*pol.unit_price/l_mau) * l_mau
                        , round((pol.quantity*pol.unit_price),l_precision)) ))
    INTO l_return_val
    FROM po_lines_archive_all pol
    WHERE pol.po_header_id = p_doc_id
    AND pol.latest_external_flag = 'Y'
    AND pol.clm_exhibit_name = p_exhibit_name;