APPS.ITG_X_UTILS SQL Statements

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

Line: 32

    CURSOR getPoLineApproval IS SELECT COUNT(*)
        FROM po_line_locations_all
                WHERE po_line_id=v_po_line_id and approved_flag='Y';

Line: 53

      SELECT s.application_column_name
        FROM fnd_id_flex_segments s,
             fnd_segment_attribute_values sav,
             fnd_segment_attribute_types sat
       WHERE s.application_id           = sav.application_id
         AND s.id_flex_code             = sav.id_flex_code
         AND s.id_flex_num              = sav.id_flex_num
         AND s.enabled_flag             = 'Y'
         AND s.application_column_name  = sav.application_column_name
         AND sav.application_id         = sat.application_id
         AND sav.id_flex_code           = sat.id_flex_code
         AND sav.id_flex_num            = p_idFlexNum
         AND sav.attribute_value        = 'Y'
         AND sav.segment_attribute_type = sat.segment_attribute_type
         AND sat.application_id         = 101
         AND sat.id_flex_code           = 'GL#'
         AND sat.unique_flag            = 'Y'
         AND sat.segment_attribute_type = p_flexQualifierName;

Line: 86

      SELECT inventory_organization_id
        FROM financials_system_params_all
       WHERE org_id=p_org_id;

Line: 100

  ** distinct for the input value, the first value selected is returned.
  */
  FUNCTION getRequistnid ( poReqDistId IN Number )
    RETURN varchar2 AS
  returnValue po_requisition_headers_all.segment1%TYPE;

Line: 106

    SELECT reqHead.segment1
      FROM po_requisition_headers_all reqHead,
           po_requisition_lines_all   reqLine,
           po_req_distributions_all   reqDist
     WHERE reqHead.requisition_header_id    = reqLine.requisition_header_id
       AND reqLine.requisition_line_id      = reqDist.requisition_line_id
       AND reqDist.distribution_id          = poReqDistId;

Line: 129

    SELECT reqLine.line_num
     FROM po_requisition_lines_all    reqLine,
          po_req_distributions_all    reqDist
    WHERE reqLine.requisition_line_id = reqDist.requisition_line_id
      AND reqDist.distribution_id     = poReqDistId;

Line: 190

      SELECT ap.tax_identification_num, ap.entity_name
      FROM ap_reporting_entities_all    ap,
           hr_all_organization_units    unit
      WHERE ap.location_id              = unit.location_id
      AND   ap.org_id                   = orgId
      AND   unit.organization_id        = orgUnit;

Line: 197

      SELECT fsp.vat_registration_num
      FROM financials_system_params_all fsp,
           inv_organization_info_v org -- Modified for performance bug#4941286
      WHERE fsp.set_of_books_id = org.set_of_books_id
      AND   org.organization_id = invOrg;

Line: 249

      SELECT id_flex_num
      FROM fnd_id_flex_structures
      WHERE application_id = appId
      AND   id_flex_code   = flexCode
      AND   enabled_flag   = 'Y';

Line: 256

      SELECT concatenated_segment_delimiter
      FROM fnd_id_flex_structures
      WHERE application_id = appId
      AND   id_flex_code   = flexCode
      AND   id_flex_num    = l_flexNum
      AND   enabled_flag   = 'Y';

Line: 263

      SELECT application_column_name col
      FROM fnd_id_flex_segments s
      WHERE application_id = appId
      AND   id_flex_code   = flexCode
      AND   id_flex_num    = l_flexNum
      AND   enabled_flag   = 'Y'
      ORDER BY segment_num;

Line: 359

      SELECT sum( quantity * price_override )
        FROM po_line_locations_all
       WHERE po_header_id = poHeaderId;

Line: 363

      SELECT sum( quantity * price_override )
        FROM po_line_locations_all
       WHERE po_header_id  = poHeaderId
         AND po_release_id = poRelease;

Line: 387

      SELECT sum( quantity * unit_price )
      FROM po_requisition_lines_all
      WHERE requisition_header_id = reqHeaderId;

Line: 405

      SELECT short.short_text FROM
        fnd_attached_documents fad,
        fnd_documents_vl fdv,
        fnd_document_entities fde,
        fnd_document_categories_vl fdcv,
        fnd_documents_short_text short
      WHERE
        fad.document_id = fdv.document_id AND
        short.media_id  = fdv.media_id AND
        fad.entity_name = fde.entity_name AND
        fdcv.category_id = fdv.category_id AND
        fde.data_object_code  = p_table_name  AND
        fad.pk1_value   = p_id          AND
        fdcv.name       = p_type
        order by short.media_id;

Line: 448

      SELECT short.short_text, fdcv.name FROM
        fnd_attached_documents fad,
        fnd_documents_vl fdv,
        fnd_document_entities fde,
        fnd_document_categories_vl fdcv,
        fnd_documents_short_text short
      WHERE
        fad.document_id = fdv.document_id AND
        short.media_id  = fdv.media_id AND
        fad.entity_name = fde.entity_name AND
        fdcv.category_id = fdv.category_id AND
        fde.data_object_code  = p_table_name  AND
        fad.pk1_value   = p_id
          order by short.media_id; -- Check if removing this makes much performance difference

Line: 601

  SELECT to_char(e.party_id), to_char(e.party_site_id)
  INTO   g_party_id,          g_party_site_id
  FROM   hr_locations_all h,
         ecx_tp_headers   e
  WHERE  h.location_id   = e.party_id
  AND    e.party_type    = c_party_type
  AND    h.location_code = c_party_site_name;

Line: 609

  SELECT name
  INTO   g_local_system
  FROM   wf_systems
  WHERE  guid = wf_core.translate('WF_SYSTEM_GUID');

Line: 617

  /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
   * Indicate that package has been properly initialized.
   */
  g_initialized   := TRUE;