DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on OKC_K_ITEMS_V

Line 580: from okc_k_items_v

576: cursor c1(p_cle_id Number) is
577: select object1_id1,
578: uom_code,
579: number_of_items
580: from okc_k_items_v
581: where cle_id = p_cle_id
582: and priced_item_yn = 'Y';
583: -- and jtot_object1_code in (G_JTF_usage,G_JTF_service);
584: l_row_notfound Boolean := True;

Line 728: From OKC_K_ITEMS_V

724:
725: /*** Item Csr - may not work for OKC Use Get_inventory_Item ***/
726: Cursor Get_Item_Csr Is
727: Select Object1_id1
728: From OKC_K_ITEMS_V
729: Where cle_id = p_contract_line_id
730: And Jtot_object1_code in(G_JTF_usage,G_JTF_service);
731:
732: /*** Get it in the above API for inv item ***/