APPS.OKS_OMINT_PUB SQL Statements

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

Line: 39

          Select Coterminate_Day_Month
          From HZ_CUST_ACCOUNTS  --OKX_CUSTOMER_ACCOUNTS_V
          Where CUST_ACCOUNT_ID = p_customer_id;

Line: 44

         Select Coterminate_Day_Month
         From CS_SYSTEMS_ALL_B --OKX_SYSTEMS_V
         Where  SYSTEM_ID = P_system_id;

Line: 49

         Select UOM_Code, Unit_Of_Measure
         From MTL_UNITS_OF_MEASURE_TL --OKX_UNITS_OF_MEASURE_V
         Where UOM_Code = p_Service_Period;

Line: 55

       Select uom_code
       from   OKC_TIME_CODE_UNITS_V
       Where tce_code = p_code
       And   quantity = p_qty;

Line: 271

        Select   Id
                ,General_YN
                ,Except_Object_Type
                ,Start_Date_Active
                ,End_Date_Active
        From     OKS_SERV_AVAILS_V
        Where    object1_id1 = p_check_service_rec.service_item_id
        And      Except_Object_type = Nvl(obj_type,Except_Object_type)
        Order By Except_Object_type;

Line: 282

        Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
        Where  Id1 = l_custid;

Line: 286

        Select distinct SERVICE_ORDER_ALLOWED_FLAG
        From   CS_CUSTOMER_PRODUCT_STATUSES
        Where  customer_product_status_id In
        (
           select customer_product_status_id From okx_customer_products_v
           where  id1 = p_check_service_rec.customer_product_id
        );

Line: 297

       Select serviceable_product_flag
       FROM mtl_system_items_b
       WHERE inventory_item_id = p_item_id
       AND rownum < 2;  */

Line: 303

       Select serviceable_product_flag
       From OKX_SYSTEM_ITEMS_V
       Where id1 = p_item_id
       And   id2 = l_organization_id;

Line: 311

       Select serviceable_product_flag
       From OKX_SYSTEM_ITEMS_V
       Where id1 = p_item_id
       And   id2 = l_organization_id;

Line: 324

    select INVENTORY_ITEM_ID
    from cs_customer_products_all
    where CUSTOMER_PRODUCT_ID = cust_prdId;

Line: 331

    select 'Y'
    from mtl_system_items
    where inventory_item_id = p_inv_item_id
    and ((bom_item_type = 1) OR
    (bom_item_type = 4 AND
    (pick_components_flag = 'Y' OR replenish_to_order_flag = 'Y')));

Line: 362

        Select  Object1_Id1,
                Start_Date_Active,
                End_Date_Active
        From    OKS_SERV_AVAIL_EXCEPTS_V
        Where   SAV_Id = p_mast_id And
                Object1_Id1 = p_prod_id;

Line: 445

          Select Object1_Id1,
                 Start_Date_Active,
                 End_Date_Active
          From   OKS_SERV_AVAIL_EXCEPTS_V
          Where  SAV_Id = p_mast_id
          And    Object1_Id1 = p_cust_id;

Line: 734

     Select INVENTORY_ITEM_ID id1
      From MTL_SYSTEM_ITEMS_B_KFV
      Where VENDOR_WARRANTY_FLAG = 'N'
      And   SERVICE_ITEM_FLAG    = 'Y'
      AND   CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
      AND   DECODE(ENABLED_FLAG,'Y','A','I')  = 'A'
      --npalepu modified on 23-dec-2005 for bug # 4897884
      /* And   ORGANIZATION_ID = okc_context.get_okc_organization_id */
      And   ORGANIZATION_ID = v_organization_id
      --end 4897884
     order by CONCATENATED_SEGMENTS;

Line: 749

        Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
        Where  Id1 = l_custid;

Line: 936

       Select    B.INVENTORY_ITEM_ID Id1,
                 T.DESCRIPTION Name,
                 B.CONCATENATED_SEGMENTS Description,
                 B.COVERAGE_SCHEDULE_ID COVERAGE_TEMPLATE_ID
       From      MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T  --OKX_SYSTEM_ITEMS_V
       Where     B.SERVICE_ITEM_FLAG='Y'
       And       B.VENDOR_WARRANTY_FLAG = 'N'
       And B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
       AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
       AND T.LANGUAGE = userenv('LANG')
       --npalepu modified on 23-dec-2005 for bug # 4897884
       /*          And    B.ORGANIZATION_ID = okc_context.get_okc_organization_id; */

Line: 952

        Select Party_Id From HZ_CUST_ACCOUNTS -- OKX_CUSTOMER_ACCOUNTS_V
        Where  CUST_ACCOUNT_ID = l_custid;

Line: 1139

        Select   Id
                ,General_YN
                ,Except_Object_Type
                ,Start_Date_Active
                ,End_Date_Active
        From     OKS_SERV_AVAILS_V
        Where    object1_id1 = p_service_id
        And      Except_Object_type = Nvl(obj_type,Except_Object_type)
        Order By Except_Object_type;

Line: 1152

          Select Object1_Id1,
                 Start_Date_Active,
                 End_Date_Active
          From   OKS_SERV_AVAIL_EXCEPTS_V
          Where  SAV_Id = p_mast_id
          And    Object1_Id1 = p_party_id;

Line: 1246

Procedure  Delete_Contract_details
                  ( p_api_version       IN Number
                   ,p_init_msg_list     IN Varchar2 Default OKC_API.G_FALSE
                   ,p_order_line_id     IN Number
                   ,x_msg_Count        OUT NOCOPY  Number
                   ,x_msg_Data         OUT  NOCOPY Varchar2
                   ,x_return_status    OUT  NOCOPY Varchar2)
Is

l_api_name        CONSTANT VARCHAR2(30) := 'GET_DURATION';

Line: 1267

       Select Id
       From   Oks_k_order_details
       Where  Order_line_id1 = to_char(l_order_line_id);

Line: 1273

        Select Id
        From   Oks_k_order_details
        Where  Link_ord_line_id1 = to_char(l_line_id);

Line: 1279

       Select Id
       From   Oks_k_order_contacts
       Where  Cod_id = l_id;

Line: 1304

                         Oks_Order_Contacts_Pub.Delete_Order_Contact
                         (
                                P_api_version   => 1.0
                               ,P_init_msg_list => 'T'
                               ,X_return_status => l_return_status
                               ,X_msg_count     => l_msg_count
                               ,X_msg_data      => l_msg_data
                               ,P_cocv_tbl      => l_coc_tbl_in

                         );

Line: 1321

                   Oks_Order_details_pub.Delete_order_detail
                   (
                       P_api_version   => 1.0
                      ,P_init_msg_list => 'T'
                      ,X_return_status => l_return_status
                      ,X_msg_count     => l_msg_count
                      ,X_msg_data      => l_msg_data
                      ,P_codv_tbl      => l_cod_tbl_in
                   );

Line: 1340

                 Oks_Order_Contacts_Pub.Delete_Order_Contact
                (
                 P_api_version   => 1.0
                ,P_init_msg_list => 'T'
                ,X_return_status => l_return_status
                ,X_msg_count     => l_msg_count
                ,X_msg_data      => l_msg_data
                ,P_cocv_tbl      => l_coc_tbl_in

               );

Line: 1357

            Oks_Order_details_pub.Delete_order_detail
            (
                       P_api_version   => 1.0
                      ,P_init_msg_list => 'T'
                      ,X_return_status => l_return_status
                      ,X_msg_count     => l_msg_count
                      ,X_msg_data      => l_msg_data
                      ,P_codv_tbl      => l_cod_tbl_in
            );

Line: 1387

END Delete_Contract_details;

Line: 1406

       Select service_reference_type_code
              ,service_reference_line_id
              ,service_duration
              ,service_period
              ,fulfillment_date
              ,org_id
              ,ship_from_org_id
              ,sold_from_org_id
       From   oe_order_lines_all
       Where  line_id = p_order_line_id;

Line: 1418

       Select max(ol.end_date)
       From okc_k_items ot, okc_k_lines_b ol
       Where ot.object1_id1 = to_char(p_cp_id) -- Bug Fix #5011519
       And   ol.id     = ot.cle_id
       And   ol.lse_id = 18   ;

Line: 1426

       /*Select  csi.instance_id
              ,csi.install_date
              ,ol.Actual_shipment_date
              ,ol.schedule_ship_date
       From    csi_item_instances csi
              ,oe_order_lines_all ol
       Where   ol.line_id = csi.last_oe_order_line_id
       And     ol.inventory_item_id = csi.inventory_item_id
       And     ol.line_id = p_line_id; */

Line: 1435

    SELECT csi.instance_id,
           csi.install_date,
           ol.actual_shipment_date,
           ol.schedule_ship_date,
           mtl.service_starting_delay
      FROM csi_item_instances csi,
           oe_order_lines_all ol,
           okx_system_items_v mtl
     WHERE csi.inventory_item_id = mtl.id1
       AND ol.inventory_item_id = csi.inventory_item_id
       AND mtl.id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID
       AND csi.last_oe_order_line_id = ol.line_id
       AND ol.line_id = p_line_id;

Line: 1450

       Select csi.install_date
       From   csi_item_instances csi
       Where  csi.instance_id = p_cp_id;

Line: 1456

  SELECT master_organization_id
    FROM oe_system_parameters_all
   WHERE org_id = p_org_id;

Line: 1615

     INSERT INTO OKS_REPROCESSING
       (ID
       ,ORDER_ID
       ,ORDER_LINE_ID
       ,CONTRACT_ID
       ,CONTRACT_LINE_ID
       ,SUBLINE_ID
       ,ERROR_TEXT
       ,SUCCESS_FLAG
       ,SOURCE_FLAG
       ,CONC_REQUEST_ID
       ,CREATED_BY
       ,CREATION_DATE
       ,LAST_UPDATED_BY
       ,LAST_UPDATE_DATE
       ,LAST_UPDATE_LOGIN
       ,OBJECT_VERSION_NUMBER
       ,SECURITY_GROUP_ID
       ,REPROCESS_YN
       ,ORDER_NUMBER )
     VALUES
       (TO_NUMBER(RAWTOHEX(SYS_GUID()),'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX')
       ,l_Order_Header_ID_Tbl(f_SrvOrdLine_Idx)
       ,l_Order_Line_ID_Tbl(f_SrvOrdLine_Idx)
       ,NULL
       ,NULL
       ,NULL
       ,NULL
       ,'N'
       ,'ASO'
       ,NULL
       ,FND_GLOBAL.USER_ID
       ,SYSDATE
       ,FND_GLOBAL.USER_ID
       ,SYSDATE
       ,FND_GLOBAL.LOGIN_ID
       ,1
       ,NULL
       ,'Y'
       ,l_Order_Number_Tbl(f_SrvOrdLine_idx));

Line: 1684

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 AND LANGUAGE = USERENV('LANG');

Line: 1693

  SELECT lse_id
  FROM   OKC_K_LINES_B
 WHERE  id = p_id;

Line: 1816

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 AND LANGUAGE = USERENV('LANG');

Line: 1824

 SELECT lse_id
 FROM   OKC_K_LINES_B
 WHERE  id = p_id;

Line: 1847

select service_period,service_duration
from  okc_k_lines_b subline,
      okc_k_rel_objs rel,
      oe_order_lines_all oel
where subline.cle_id = p_id
and   rel.cle_id = subline.id
and   oel.line_id  = rel.object1_id1;*/

Line: 2054

    SELECT
        kfv.organization_id            Organization_id,
        kfv.inventory_item_id          id1,
        kfv.concatenated_segments      Concatenated_segments,
        kfv.description                Description,
        kfv.primary_uom_code           Primary_uom_code,
        uom.description                Primary_uom_description,
        kfv.Serviceable_product_flag   Serviceable_product_flag,
        kfv.service_item_flag          Service_item_flag,
        kfv.bom_item_type              Bom_item_type,
        fnd.meaning                    Bom_item_type_meaning,
        kfv.item_type                  Item_type,
        fnd1.meaning                   Item_type_meaning,
        kfv.service_duration           Service_duration,
        kfv.service_duration_period_code Service_duration_period_code,
        srvuom.description             Service_duration_period_mean,
        kfv.shippable_item_flag        shippable_item_flag,
        kfv.returnable_flag            Returnable_flag
    FROM    MTL_SYSTEM_ITEMS_B_KFV kfv,
            MTL_UNITS_OF_MEASURE_VL uom,
            MTL_UNITS_OF_MEASURE_VL srvuom,
            FND_LOOKUP_VALUES fnd,
            FND_LOOKUP_VALUES fnd1
    WHERE   kfv.vendor_warranty_flag = 'N'
    AND     kfv.service_item_flag    = 'Y'
    AND     kfv.customer_order_enabled_flag = 'Y'
    AND     kfv.enabled_flag  = 'Y'
    --npalepu modified on 23-dec-2005 for bug # 4897884
    /* AND     kfv.organization_id = okc_context.get_okc_organization_id */
    AND     kfv.organization_id = v_organization_id
    --end npalepu
    --NPALEPU,11-AUG-2005
    --Used UPPER Function as Requested by Quoting Team.
    --AND     (kfv.concatenated_segments LIKE P_search_input OR kfv.description LIKE P_search_input )
    AND     (UPPER(kfv.concatenated_segments) LIKE UPPER(P_search_input) OR UPPER(kfv.description) LIKE UPPER(P_search_input) )
    --END NPALEPU
    AND     uom.uom_code     = primary_uom_code
    AND     srvuom.uom_code  = service_duration_period_code
    AND     fnd.lookup_type  = 'BOM_ITEM_TYPE'
    AND     fnd.lookup_code  = bom_item_type
    AND     fnd.language     = USERENV('LANG')
    AND     fnd1.lookup_type = 'ITEM_TYPE'
    AND     fnd1.lookup_code = item_type
    AND     fnd1.language    = USERENV('LANG')
    ORDER BY CONCATENATED_SEGMENTS;

Line: 2104

    SELECT
        kfv.organization_id            Organization_id,
        kfv.inventory_item_id          id1,
        kfv.concatenated_segments      Concatenated_segments,
        kfv.description                Description,
        kfv.primary_uom_code           Primary_uom_code,
        uom.description                Primary_uom_description,
        kfv.Serviceable_product_flag   Serviceable_product_flag,
        kfv.service_item_flag          Service_item_flag,
        kfv.bom_item_type              Bom_item_type,
        fnd.meaning                    Bom_item_type_meaning,
        kfv.item_type                  Item_type,
        fnd1.meaning                   Item_type_meaning,
        kfv.service_duration           Service_duration,
        kfv.service_duration_period_code Service_duration_period_code,
        srvuom.description             Service_duration_period_mean,
        kfv.shippable_item_flag        shippable_item_flag,
        kfv.returnable_flag            Returnable_flag
    FROM    MTL_SYSTEM_ITEMS_B_KFV kfv,
            MTL_UNITS_OF_MEASURE_VL uom,
            MTL_UNITS_OF_MEASURE_VL srvuom,
            FND_LOOKUP_VALUES fnd,
            FND_LOOKUP_VALUES fnd1
    WHERE   kfv.vendor_warranty_flag = 'N'
    AND     kfv.service_item_flag    = 'Y'
    AND     kfv.customer_order_enabled_flag = 'Y'
    AND     kfv.enabled_flag  = 'Y'
    --npalepu modified on 23-dec-2005 for bug # 4897884
    /* AND     kfv.organization_id = okc_context.get_okc_organization_id */
    AND     kfv.organization_id = v_organization_id
    --end npalepu
    AND     uom.uom_code     = primary_uom_code
    AND     srvuom.uom_code  = service_duration_period_code
    AND     fnd.lookup_type  = 'BOM_ITEM_TYPE'
    AND     fnd.lookup_code  = bom_item_type
    AND     fnd.language     = USERENV('LANG')
    AND     fnd1.lookup_type = 'ITEM_TYPE'
    AND     fnd1.lookup_code = item_type
    AND     fnd1.language    = USERENV('LANG')
    ORDER BY CONCATENATED_SEGMENTS;

Line: 2146

        Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
        Where  Id1 = l_custid;