APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 758: FROM MTL_SYSTEM_ITEMS_B

754: -- SECHAWLA 18-OCT-04 3924244 : new declarations
755: -- check if item already exists in inventory
756: CURSOR l_mtlsystemitems_csr(cp_inv_item_number IN VARCHAR2) IS
757: SELECT count(*)
758: FROM MTL_SYSTEM_ITEMS_B
759: WHERE segment1 = cp_inv_item_number;
760:
761: l_item_cnt NUMBER;
762:

Line 1869: FROM mtl_system_items_b

1865:
1866: -- This cursor is used to make sure that the item exists in active state, before removing the item
1867: CURSOR l_mtlsysitems_csr(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
1868: SELECT 'x'
1869: FROM mtl_system_items_b
1870: WHERE inventory_item_id = p_inventory_item_id
1871: AND organization_id = p_organization_id
1872: AND end_date_active IS NULL;
1873: */