APPS.PO_REQS_INQ_SV SQL Statements

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

Line: 25

    SELECT POH.segment1
      INTO X_po_number
      FROM PO_HEADERS_ALL POH              -- FPI GA
     WHERE POH.PO_HEADER_ID = X_po_header_id;

Line: 105

         /* replacing the select statement with the new OE API. */
          select order_source_id
          into   x_order_source_id
          from   po_system_parameters;

Line: 122

   /*    SELECT decode(SOL.shipped_quantity,NULL,0,SOL.shipped_quantity)
         INTO   X_shipped_quantity
         FROM   SO_LINES SOL, SO_HEADERS SOH,
                PO_SYSTEM_PARAMETERS POSP
         WHERE  SOH.original_system_reference = X_requisition_num
         AND    SOH.original_system_source_code =
                             to_char(POSP.order_source_id)
         AND    SOH.header_id = SOL.header_id
         AND    SOL.original_system_line_reference = X_line_num;

Line: 350

  select displayed_field
  from po_lookup_codes
  where lookup_type = x_lookup_type
  and lookup_code = x_lookup_code;

Line: 432

    SELECT POH.global_agreement_flag, POH.org_id
    INTO   X_ga_flag, X_owning_org_id
    FROM   PO_HEADERS_ALL POH
    WHERE  POH.PO_HEADER_ID = X_po_header_id;

Line: 437

    SELECT  name
    INTO    X_owning_org_name
    FROM    hr_organization_units
    WHERE   organization_id =  X_owning_org_id;

Line: 503

    Select plt.order_type_lookup_code
    Into   l_value_basis
    From   po_line_types_b plt,
           po_requisition_lines_all prl  --
    Where  plt.line_type_id = prl.line_type_id
    And    prl.requisition_line_id = p_req_entity_id;

Line: 518

    Select plt.order_type_lookup_code
    Into   l_value_basis
    From   po_line_types_b plt,
           po_requisition_lines_all prl,  --
           po_req_distributions_all prd  --
    Where  plt.line_type_id = prl.line_type_id
    And    prl.requisition_line_id = prd.requisition_line_id
    And    prd.distribution_id = p_req_entity_id;

Line: 538

         Select prl.amount
         Into   l_req_amount
         From   po_requisition_lines_all prl  --
         Where  prl.requisition_line_id = p_req_entity_id;

Line: 549

         Select prd.req_line_amount
         Into   l_req_amount
         From   po_req_distributions_all prd  --
         Where  prd.distribution_id = p_req_entity_id;