APPS.OKC_PRICE_PUB dependencies on OKX_SYSTEM_ITEMS_V

Line 735: From OKX_SYSTEM_ITEMS_V

731:
732: /*** Get it in the above API for inv item ***/
733: Cursor Get_usage_flag_Csr(l_id Number) Is
734: Select Usage_item_flag
735: From OKX_SYSTEM_ITEMS_V
736: Where id1 = l_id ;
737:
738: /**** Party Csr - Assumes a header party, we might have line too ***/
739: Cursor Get_party_Csr (p_Kid Number) Is

Line 1958: select primary_uom_code from OKX_SYSTEM_ITEMS_V

1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;
1955: l_rel_index NUMBER;
1956:
1957: CURSOR puom_cur(p_inv_id NUMBER) IS
1958: select primary_uom_code from OKX_SYSTEM_ITEMS_V
1959: WHERE ID1 = p_inv_id;
1960: BEGIN
1961: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1962:

Line 2275: FROM okx_system_items_v

2271: G_Item_Segments.segment10,G_Item_Segments.segment11,G_Item_Segments.segment12,
2272: G_Item_Segments.segment13,G_Item_Segments.segment14,G_Item_Segments.segment15,
2273: G_Item_Segments.segment16,G_Item_Segments.segment17,G_Item_Segments.segment18,
2274: G_Item_Segments.segment19,G_Item_Segments.segment20
2275: FROM okx_system_items_v
2276: WHERE inventory_item_id = p_inventory_item_id
2277: AND organization_id = p_org_id;
2278: ---FROM mtl_system_items
2279: --- WHERE inventory_item_id = p_inventory_item_id