APPS.INV_3PL_SEEDED_SOURCES dependencies on MTL_SYSTEM_ITEMS_KFV

Line 48: SELECT * FROM mtl_system_items_kfv msib

44: )
45: as
46:
47: CURSOR items_record(p_client_code VARCHAR2) IS
48: SELECT * FROM mtl_system_items_kfv msib
49: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
50: AND nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
51: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
52: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';