APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 82: FROM MTL_SYSTEM_ITEMS_B

78:
79: -- check if item already exists in inventory
80: CURSOR l_mtlsystemitems_csr(cp_inv_item_number IN VARCHAR2) IS
81: SELECT count(*)
82: FROM MTL_SYSTEM_ITEMS_B
83: WHERE segment1 = cp_inv_item_number;
84:
85: -- validate item template
86: CURSOR l_mtltemplates_csr(cp_item_templ_id IN NUMBER, cp_org_id IN NUMBER) IS

Line 1418: FROM mtl_system_items_b

1414:
1415: -- SECHAWLA 08-DEC-04 4047159 : Added
1416: CURSOR l_mtlsystemitems_b(cp_item_id IN NUMBER) IS
1417: SELECT segment1
1418: FROM mtl_system_items_b
1419: WHERE inventory_item_id = cp_item_id;
1420:
1421: l_pricelist_name QP_LIST_HEADERS.name%TYPE;
1422: l_item_number VARCHAR2(40);