APPS.OZF_TP_UTIL_QUERIES SQL Statements

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

Line: 36

          SELECT
            MTD_ALERT INTO x_return_value
          FROM
            ozf_quota_alerts
          WHERE
               ship_to_site_use_id = p_object_id
          AND report_date = p_report_date
          AND resource_id = p_resource_id
          AND alert_for = p_alert_for;

Line: 46

          SELECT
            QTD_ALERT INTO x_return_value
          FROM
            ozf_quota_alerts
          WHERE
               ship_to_site_use_id = p_object_id
          AND report_date = p_report_date
          AND resource_id = p_resource_id
          AND alert_for = p_alert_for;

Line: 56

          SELECT
            YTD_ALERT INTO x_return_value
          FROM
            ozf_quota_alerts
          WHERE
               ship_to_site_use_id = p_object_id
          AND report_date = p_report_date
          AND resource_id = p_resource_id
          AND alert_for = p_alert_for;

Line: 66

          SELECT
            BACK_ORDER_ALERT INTO x_return_value
          FROM
            ozf_quota_alerts
          WHERE
               ship_to_site_use_id = p_object_id
          AND report_date = p_report_date
          AND resource_id = p_resource_id
          AND alert_for = p_alert_for;

Line: 76

          SELECT
            OUTSTAND_ORDER_ALERT INTO x_return_value
          FROM
            ozf_quota_alerts
          WHERE
               ship_to_site_use_id = p_object_id
          AND report_date = p_report_date
          AND resource_id = p_resource_id
          AND alert_for = p_alert_for;

Line: 121

       SELECT
         MTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           cust_account_id = p_cust_account_id
       AND ship_to_site_use_id = p_site_use_id
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 132

       SELECT
         QTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           cust_account_id = p_cust_account_id
       AND ship_to_site_use_id = p_site_use_id
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 143

       SELECT
         YTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           cust_account_id = p_cust_account_id
       AND ship_to_site_use_id = p_site_use_id
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 154

       SELECT
         BACK_ORDER_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           cust_account_id = p_cust_account_id
       AND ship_to_site_use_id = p_site_use_id
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 165

       SELECT
         OUTSTAND_ORDER_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           cust_account_id = p_cust_account_id
       AND ship_to_site_use_id = p_site_use_id
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 212

       SELECT
         MTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           product_attribute = p_product_attribute
       AND product_attr_value = p_product_attr_value
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 223

       SELECT
         QTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           product_attribute = p_product_attribute
       AND product_attr_value = p_product_attr_value
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 234

       SELECT
         YTD_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           product_attribute = p_product_attribute
       AND product_attr_value = p_product_attr_value
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 245

       SELECT
         BACK_ORDER_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           product_attribute = p_product_attribute
       AND product_attr_value = p_product_attr_value
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 256

       SELECT
         OUTSTAND_ORDER_ALERT INTO x_return_value
       FROM
         ozf_quota_alerts
       WHERE
           product_attribute = p_product_attribute
       AND product_attr_value = p_product_attr_value
       AND report_date = p_report_date
       AND resource_id = p_resource_id
       AND alert_for = p_alert_for;

Line: 290

 SELECT
     NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) from DUAL;

Line: 301

      Select p.party_name||' '||d.location into x_return_value
        from hz_parties p,
             hz_cust_acct_sites c,
             hz_cust_site_uses d,
             hz_cust_accounts e
       where d.site_use_id = p_site_use_id
         and d.cust_acct_site_id = c.cust_acct_site_id
         and e.cust_account_id = c.cust_account_id
         and p.party_id = e.party_id;

Line: 332

          SELECT schedule_name
            INTO x_return_value
            FROM ams_campaign_schedules_tl
           WHERE schedule_id = activity_id
             AND language = userenv('LANG');

Line: 338

          SELECT description
            INTO x_return_value
            FROM qp_list_headers_tl
           WHERE list_header_id = activity_id
             AND language = userenv('LANG');

Line: 344

          SELECT campaign_name
            INTO x_return_value
            FROM ams_campaigns_all_tl
           WHERE campaign_id = activity_id
             AND language = userenv('LANG');

Line: 370

         select count(act.object_id)  into x_object_count
           from ams_act_access_denorm act, qp_list_headers_b qp, ozf_offers off
          where act.object_id = p_object_id
            and act.object_type = p_object_class
            and act.resource_id= p_resource_id
            and qp.list_header_id = act.object_id
            and off.qp_list_header_id = act.object_id
            and qp.source_system_code =  FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')
            and NVL(off.budget_offer_yn,'N') = 'N';

Line: 380

            select count(act.object_id) into x_object_count
              from ams_act_access_denorm act
             where act.object_id = p_object_id
               and act.object_type = p_object_class
               and act.resource_id= p_resource_id;

Line: 411

      select inv_convert.inv_um_convert(p_object_id,null,p_qty,p_from_uom,p_to_uom,null,null)
        into x_return_value
        from dual;

Line: 481

  SELECT qualifier_context,
         qualifier_attribute,
         qualifier_attr_value
  FROM ozf_worksheet_qualifiers
  WHERE worksheet_header_id = p_obj_id;

Line: 617

        IF l_status_code <> 'UPDATED'
        THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 671

    SELECT NVL(quota_unit,'Q')
    FROM ozf_sys_parameters;

Line: 698

  SELECT
       NVL(d.category_desc, c.description) cat_descr
       --NVL(d.concat_cat_parentage, c.description) cat_descr
  FROM  mtl_default_category_sets a,
      mtl_category_sets_b b,
      mtl_categories_v c,
      ENI_PROD_DEN_HRCHY_PARENTS_V d
  WHERE a.functional_area_id IN (7, 11)
  AND a.category_set_id = b.category_set_id
  AND b.structure_id = c.structure_id
  AND c.category_id = d.category_id(+)
  AND c.category_id = p_attr_value;

Line: 735

     select description into l_item_name
       from mtl_system_items_vl
      where inventory_item_id = p_inventory_item_id
        and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');