APPS.OKC_PRICE_PUB SQL Statements

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

Line: 84

           SELECT Minimum_Accountable_Unit,
                  Precision,
                  Extended_Precision
           FROM FND_CURRENCIES
           WHERE Currency_Code = p_cur_code ;

Line: 172

PROCEDURE Update_CONTRACT_price(
          p_api_version                 IN          NUMBER,
          p_init_msg_list               IN          VARCHAR2 ,
          p_commit                      IN          VARCHAR2 ,
          p_CHR_ID                      IN          NUMBER,
          px_Control_Rec			    IN  OUT NOCOPY     PRICE_CONTROL_REC_TYPE,
          x_CLE_PRICE_TBL		        OUT  NOCOPY CLE_PRICE_TBL_TYPE,
          x_chr_net_price               OUT  NOCOPY NUMBER,
          x_return_status               OUT  NOCOPY VARCHAR2,
          x_msg_count                   OUT  NOCOPY NUMBER,
          x_msg_data                    OUT  NOCOPY VARCHAR2) IS

          l_control_rec                  OKC_CONTROL_REC_TYPE;

Line: 194

         OKC_PRICE_PVT.Update_CONTRACT_price(
          p_api_version                 =>  p_api_version,
          p_init_msg_list               =>  p_init_msg_list,
          p_commit                      =>  p_commit,
          p_CHR_ID                      =>  p_CHR_ID,
          px_Control_Rec			    =>  l_Control_Rec,
          x_CLE_PRICE_TBL		        =>  x_CLE_PRICE_TBL,
          x_chr_net_price               =>  x_chr_net_price,
          x_return_status               =>  x_return_status,
          x_msg_count                   =>  x_msg_count,
          x_msg_data                    =>  x_msg_data);

Line: 205

    END UPDATE_CONTRACT_PRICE;

Line: 224

PROCEDURE Update_LINE_price(
          p_api_version                 IN          NUMBER,
          p_init_msg_list               IN          VARCHAR2 ,
          p_commit                      IN          VARCHAR2 ,
          p_CHR_ID                      IN          NUMBER,
          p_cle_id			            IN	        NUMBER ,
          p_lowest_level                IN          NUMBER ,
          px_Control_Rec			    IN   OUT NOCOPY    PRICE_CONTROL_REC_TYPE,
          px_chr_list_price             IN   OUT NOCOPY    NUMBER,
          px_chr_net_price              IN   OUT NOCOPY    NUMBER,
          x_CLE_PRICE_TBL		        OUT  NOCOPY CLE_PRICE_TBL_TYPE,
          px_cle_amt    		        IN   OUT NOCOPY    NUMBER,
          x_return_status               OUT  NOCOPY VARCHAR2,
          x_msg_count                   OUT  NOCOPY NUMBER,
          x_msg_data                    OUT  NOCOPY VARCHAR2)IS

          l_control_rec                  OKC_CONTROL_REC_TYPE;

Line: 250

        OKC_PRICE_PVT.Update_LINE_price(
          p_api_version                 =>          p_api_version,
          p_init_msg_list               =>         p_init_msg_list,
          p_commit                      =>         p_commit,
          p_CHR_ID                      =>          p_CHR_ID,
          p_cle_id			            =>	        p_cle_id,
          p_lowest_level                =>          p_lowest_level,
          px_Control_Rec			    =>          l_Control_Rec,
          px_chr_list_price             =>          px_chr_list_price,
          px_chr_net_price              =>          px_chr_net_price,
          x_CLE_PRICE_TBL		        =>          x_CLE_PRICE_TBL,
          px_cle_amt    		        =>          px_cle_amt,
          x_return_status               =>          x_return_status,
          x_msg_count                   =>          x_msg_count,
          x_msg_data                    =>          x_msg_data);

Line: 265

     END UPDATE_LINE_PRICE;

Line: 313

  select rul.object1_id1
    from okc_rules_b rul,
         okc_rule_groups_b rgp
   where rul.rgp_id = rgp.id
     and rul.rule_information_category = p_category
     and rul.jtot_object1_code = p_object_code
     and rgp.cle_id = p_cle_id;

Line: 337

  select rul.object1_id1,
	    rul.jtot_object1_code
    from okc_rules_b rul,
         okc_rule_groups_b rgp
   where rul.rgp_id = rgp.id
     and rul.rule_information_category = p_category
     and rgp.cle_id = p_cle_id;

Line: 370

  select rul.object1_id1
    from okc_rules_b rul,
         okc_rule_groups_b rgp
   where rul.rgp_id = rgp.id
     and rul.rule_information_category = p_category
     and rul.jtot_object1_code = p_object_code
     and rgp.chr_id = p_chr_id;

Line: 395

  select rul.object1_id1,
	    rul.jtot_object1_code
    from okc_rules_b rul,
         okc_rule_groups_b rgp
   where rul.rgp_id = rgp.id
     and rul.rule_information_category = p_category
     and rgp.chr_id = p_chr_id;

Line: 432

  select 'x'
    from fnd_application app,
         fnd_product_installations prd
   where app.application_short_name = p_product_name
     and app.application_id = prd.application_id
	 and prd.status in(p_status,p_status1);

Line: 467

  select cle_id_ascendant
    from okc_ancestrys_v
   where cle_id = p_cle_id
   order by level_sequence desc;

Line: 472

  select dnz_chr_id
    from okc_k_lines_b
   where id = p_cle_id;

Line: 577

  select object1_id1,
         uom_code,
         number_of_items
    from okc_k_items_v
   where cle_id = p_cle_id
     and priced_item_yn = 'Y';

Line: 634

  select currency_code
    from okc_k_headers_b
   where id = p_chr_id;

Line: 638

  select k.currency_code
    from okc_k_headers_b k,
         okc_k_lines_b b
   where b.id = p_cle_id
     and k.id = b.dnz_chr_id;

Line: 703

        Select  dnz_chr_id
         ,Start_date
         ,End_Date
         ,sts_code
        From   OKC_K_LINES_B
         Where  Id = p_contract_line_id;

Line: 711

        Select  Currency_code
               ,Cust_po_number
           ,scs_code
        From    OKC_K_HEADERS_B
        Where   id = p_hdr_id;

Line: 718

        Select   Isa_Agreement_id
        From     OKC_GOVERNANCES_V
        Where  dnz_chr_id =  p_id
	   AND    cle_id IS NULL;

Line: 727

        Select   Object1_id1
        From     OKC_K_ITEMS_V
        Where    cle_id = p_contract_line_id
        And      Jtot_object1_code in(G_JTF_usage,G_JTF_service);

Line: 734

 Select Usage_item_flag
 From   OKX_SYSTEM_ITEMS_V
 Where  id1 = l_id ;

Line: 740

 Select   object1_id1
 From     OKC_K_PARTY_ROLES_B
 Where    dnz_chr_id = p_kid
 And     Jtot_Object1_code = G_JTF_PARTY;

Line: 747

 Select   OBJECT1_ID1,
               RULE_INFORMATION1,
               RULE_INFORMATION2,
               RULE_INFORMATION3,
               RULE_INFORMATION4
 From     OKC_RULE_GROUPS_B  RG
  ,OKC_RULES_B        RL
 Where    RG.CLE_ID = p_contract_line_id
 AND      RG.ID     = RL.RGP_ID
 AND      RULE_INFORMATION_CATEGORY = l_cat;

Line: 759

               Select    c.id1
  from OKX_CUST_SITE_USES_V a, okx_customer_accounts_v c
  where a.party_id = p_party_id and
   c.id1 = a.CUST_ACCOUNT_ID  and
   a.Id1 = p_bill_to_id And  a.Name = 'BILL_TO';

Line: 928

  select pricing_context,
	    pricing_attribute1,  pricing_attribute2,  pricing_attribute3,  pricing_attribute4,
	    pricing_attribute5,  pricing_attribute6,  pricing_attribute7,  pricing_attribute8,
	    pricing_attribute9,  pricing_attribute10, pricing_attribute11, pricing_attribute12,
	    pricing_attribute13, pricing_attribute14, pricing_attribute15, pricing_attribute16,
	    pricing_attribute17, pricing_attribute18, pricing_attribute19, pricing_attribute20,
	    pricing_attribute21, pricing_attribute22, pricing_attribute23, pricing_attribute24,
	    pricing_attribute25, pricing_attribute26, pricing_attribute27, pricing_attribute28,
	    pricing_attribute29, pricing_attribute30, pricing_attribute31, pricing_attribute32,
	    pricing_attribute33, pricing_attribute34, pricing_attribute35, pricing_attribute36,
	    pricing_attribute37, pricing_attribute38, pricing_attribute39, pricing_attribute40,
	    pricing_attribute41, pricing_attribute42, pricing_attribute43, pricing_attribute44,
	    pricing_attribute45, pricing_attribute46, pricing_attribute47, pricing_attribute48,
	    pricing_attribute49, pricing_attribute50, pricing_attribute51, pricing_attribute52,
	    pricing_attribute53, pricing_attribute54, pricing_attribute55, pricing_attribute56,
	    pricing_attribute57, pricing_attribute58, pricing_attribute59, pricing_attribute60,
	    pricing_attribute61, pricing_attribute62, pricing_attribute63, pricing_attribute64,
	    pricing_attribute65, pricing_attribute66, pricing_attribute67, pricing_attribute68,
	    pricing_attribute69, pricing_attribute70, pricing_attribute71, pricing_attribute72,
	    pricing_attribute73, pricing_attribute74, pricing_attribute75, pricing_attribute76,
	    pricing_attribute77, pricing_attribute78, pricing_attribute79, pricing_attribute80,
	    pricing_attribute81, pricing_attribute82, pricing_attribute83, pricing_attribute84,
	    pricing_attribute85, pricing_attribute86, pricing_attribute87, pricing_attribute88,
	    pricing_attribute89, pricing_attribute90, pricing_attribute91, pricing_attribute92,
	    pricing_attribute93, pricing_attribute94, pricing_attribute95, pricing_attribute96,
	    pricing_attribute97, pricing_attribute98, pricing_attribute99, pricing_attribute100
    from okc_price_att_values_v
   where cle_id = p_contract_line_id;

Line: 1958

  select primary_uom_code from OKX_SYSTEM_ITEMS_V
  WHERE  ID1 = p_inv_id;

Line: 2106

        SELECT customer_class_code,
               sales_channel_code,
               gsa_indicator
        INTO   G_Customer_Info.customer_class_code,
               G_Customer_Info.sales_channel_code,
               G_Customer_Info.gsa_indicator
---FROM   ra_customers
	FROM  OKX_CUSTOMER_ACCOUNTS_V
        WHERE ID1 = p_cust_id;

Line: 2127

	SELECT distinct PROFILE_CLASS_ID
           BULK COLLECT INTO l_temp_tbl
	FROM   OKX_CUSTOMER_PROFILES_V
        WHERE  	cust_account_id = p_cust_id;

Line: 2146

        l_temp_tbl.delete;

Line: 2150

   SELECT ID1
	BULK COLLECT INTO l_temp_tbl
	FROM   OKX_CUST_ACCT_RELATE_V
    WHERE  customer_id = p_cust_id;

Line: 2181

SELECT ic.id1
     BULK COLLECT
INTO x_category_ids
FROM   OKX_ITEM_CATEGORIES_V  ic,
       MTL_CATEGORIES_B c,
       FND_ID_FLEX_STRUCTURES fs
WHERE  c.category_id = ic.category_id
  AND  c.structure_id = fs.id_flex_num
  AND  fs.id_flex_structure_code = 'ITEM_CATEGORIES'
  AND  ic.inventory_item_id = p_inventory_item_id
  AND  ic.organization_id = p_org_id;

Line: 2194

  SELECT ID1
         BULK COLLECT
         INTO x_category_ids
  FROM   OKX_ITEM_CATEGORIES_V
  WHERE  inventory_item_id = p_inventory_item_id
  AND    organization_id = p_org_id;

Line: 2263

  SELECT  segment1,segment2,segment3,segment4,segment5,
          segment6,segment7,segment8,segment9,segment10,
          segment11,segment12,segment13,segment14,segment15,
          segment16,segment17,segment18,segment19,segment20
  INTO
	  G_Item_Segments.segment1,G_Item_Segments.segment2,G_Item_Segments.segment3,
	  G_Item_Segments.segment4,G_Item_Segments.segment5,G_Item_Segments.segment6,
	  G_Item_Segments.segment7,G_Item_Segments.segment8,G_Item_Segments.segment9,
	  G_Item_Segments.segment10,G_Item_Segments.segment11,G_Item_Segments.segment12,
	  G_Item_Segments.segment13,G_Item_Segments.segment14,G_Item_Segments.segment15,
	  G_Item_Segments.segment16,G_Item_Segments.segment17,G_Item_Segments.segment18,
	  G_Item_Segments.segment19,G_Item_Segments.segment20
  FROM okx_system_items_v
  WHERE   inventory_item_id = p_inventory_item_id
  AND     organization_id = p_org_id;

Line: 2411

 SELECT party_id
 FROM   okx_customer_accounts_v
 WHERE  id1 = l_sold_to_org_id;

Line: 2433

 SELECT a.party_site_id
 FROM   okx_cust_sites_v a,
        okx_cust_site_uses_v b
 WHERE  a.cust_acct_site_id = b.cust_acct_site_id
 AND    b.id1               = l_ship_to_org_id
 AND    b.site_use_code     = 'SHIP_TO';

Line: 2467

 SELECT a.party_site_id
 FROM   okx_cust_sites_v a,
        okx_cust_site_uses_v b
 WHERE  a.cust_acct_site_id = b.cust_acct_site_id
 AND    b.id1               = l_bill_to_org_id
 AND    b.site_use_code     = 'BILL_TO';