APPS.OKL_AM_ASSET_RETURN_PVT dependencies on MTL_SYSTEM_ITEMS_VL
Line 475: FROM MTL_SYSTEM_ITEMS_VL st, OKX_MODEL_LINES_V ml
471:
472: -- This cursor is used to get the item catalog
473: CURSOR l_catgrp_csr(p_id NUMBER) IS
474: SELECT st.item_catalog_group_id 475: FROM MTL_SYSTEM_ITEMS_VL st, OKX_MODEL_LINES_V ml 476: WHERE ml.inventory_item_id = st.inventory_item_id
477: AND ml.parent_line_id = p_id;
478:
479: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;