APPS.PO_SHARED_PROC_PVT SQL Statements

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

Line: 254

  SELECT gsb.chart_of_accounts_id
  INTO l_coa_id
  FROM gl_sets_of_books gsb,
       hr_organization_information hoi,
       mtl_parameters mp
  WHERE mp.organization_id = p_inv_org_id
    AND mp.organization_id = hoi.organization_id
    AND hoi.org_information_context = 'Accounting Information'
    AND TO_NUMBER(hoi.org_information1) = gsb.set_of_books_id;

Line: 321

  SELECT TO_NUMBER(hoi.org_information3), gsb.chart_of_accounts_id
  INTO x_ou_id, x_coa_id
  FROM gl_sets_of_books gsb,
       hr_organization_information hoi,
       mtl_parameters mp
  WHERE mp.organization_id = p_inv_org_id
    AND mp.organization_id = hoi.organization_id
    AND hoi.org_information_context = 'Accounting Information'
    AND TO_NUMBER(hoi.org_information1) = gsb.set_of_books_id;

Line: 450

    SELECT 'Y'
    INTO    l_valid_pa_project_referenced
    FROM    po_requisition_lines_all prl
    WHERE   prl.requisition_line_id = p_requisition_line_id
      AND   prl.destination_type_code = 'EXPENSE'
      AND   EXISTS
              (SELECT 'valid pa information'
               FROM    po_req_distributions_all prd                 -- 
               WHERE   prd.requisition_line_id = p_requisition_line_id
               AND     prd.project_id IS NOT NULL);

Line: 692

       SELECT prl.category_id,
              nvl(prl.destination_organization_id, fsp.inventory_organization_id),
              prl.deliver_to_location_id
       INTO   l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
       FROM   po_requisition_lines_all prl, financials_system_params_all fsp
       WHERE  prl.requisition_line_id = p_requisition_line_id
       AND    prl.org_id = fsp.org_id; -- Bug 3379488: Use base table for joins

Line: 819

                SELECT prl.purchase_basis,
                       hrou_po.business_group_id,
                       hrou_req.business_group_id
                INTO   l_purchase_basis,
                       l_pou_bus_group_id,
                       l_rou_bus_group_id
                FROM   po_requisition_lines_all prl,
                       hr_all_organization_units hrou_po,
                       hr_all_organization_units hrou_req
                WHERE  prl.requisition_line_id = p_requisition_line_id
                AND    hrou_po.organization_id = p_purchasing_org_id
                AND    hrou_req.organization_id = p_requesting_org_id;

Line: 848

         SELECT 'Y'
         INTO   l_is_customer_location
         FROM   HZ_LOCATIONS
         WHERE  nvl(address_expiration_date, trunc(sysdate + 1)) > trunc(sysdate)
         AND    location_id = l_deliver_to_location_id;

Line: 899

          SELECT prl.category_id,
                 nvl(prl.destination_organization_id,
                     fsp.inventory_organization_id),
                 prl.deliver_to_location_id
          INTO   l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
          FROM   po_requisition_lines_all prl, financials_system_params_all fsp
          WHERE  prl.requisition_line_id = p_requisition_line_id
          AND    prl.org_id = fsp.org_id;

Line: 1154

                SELECT 'Y'
                  INTO l_valid_flag
                  FROM mtl_system_items_b msi,
                       mtl_parameters mp
                 WHERE msi.inventory_item_id = p_item_id
                   AND msi.organization_id = p_inv_org_id
                   AND mp.organization_id = msi.organization_id;

Line: 1166

                SELECT 'Y'
                  INTO l_valid_flag
                  FROM mtl_system_items_b msi,
                       mtl_item_revisions_b mir,
                       mtl_parameters mp
                 WHERE msi.inventory_item_id = p_item_id
                   AND msi.organization_id = p_inv_org_id
                   AND mir.organization_id = msi.organization_id
                   AND mir.inventory_item_id = msi.inventory_item_id
                   AND mir.revision = p_item_revision
                   AND mp.organization_id = msi.organization_id;

Line: 1318

    SELECT org_id,
           set_of_books_id,
           NVL(purch_encumbrance_flag, 'N'),
           NVL(req_encumbrance_flag, 'N')
      INTO l_current_ou_id,
           l_current_sob_id,
           l_current_p_enc_flag,
           l_current_r_enc_flag
      FROM financials_system_parameters;

Line: 1332

    SELECT TO_NUMBER(hoi.org_information3),
           TO_NUMBER(hoi.org_information1)
           -- MC INVCONV START
           --mp.process_enabled_flag
           -- MC INVCONV END
      INTO l_end_ou_id,
           l_ship_to_org_sob_id
           --l_ship_to_org_opm_flag
      FROM hr_organization_information hoi
           --mtl_parameters mp
     WHERE
     -- MC INVCONV START
         hoi.organization_id = p_ship_to_org_id
       --mp.organization_id = p_ship_to_org_id
       --AND mp.organization_id = hoi.organization_id
     -- MC INVCONV END
       AND hoi.org_information_context = 'Accounting Information';

Line: 1657

  SELECT from_organization_id
  INTO l_logical_inv_org_id
  FROM MTL_TRANSACTION_FLOW_LINES
  WHERE header_id = p_transaction_flow_header_id AND
        line_number = 1;

Line: 1696

      select user_defined_po_num_code, manual_po_num_type
      into  x_po_num_code, x_po_num_type
      from  po_system_parameters_all
      where org_id = p_org_id;