APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 83: FROM MTL_SYSTEM_ITEMS_B

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

Line 1422: FROM mtl_system_items_b

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